Re: DB_LOCALE - how to reset

En Elena Korol va escriure el dia 13 Jun 2000, a les 17:36: > Hi everyone, > > Please, help me with the following problem: > One of our newly created databases suddenly got a DB_LOCALE of en_US.1252, > and the rest of DB staff is > created and should be en_US.819 for Solaris 2.5 and higher. > What would be a proper procedure to reset the value of this variable, and > prevent this from happening again? > Can I do it on 'live' database, or it should be brought down? > > Appreciate your time, > Sincerely, > > Elena. > Please, reply to : > ekorol@styleclick.com > > a) Unload your data base. Drop your database. change the env variables create your database reload data. b) Create a parallel database (same schema) load data from database_1 to database_2 drop database_1 rename database_2 to database_1 I hope this help you. --------------------------------------- Isidre PONS ROCA BASE - Gesti' d'Ingressos Locals (Diputacio de Tarragona) Servei de Sistemes de Informacio Av President Lluis Companys 12-C 43005 - Tarragona SPAIN Tel # +34 977 236731 Fax # +34 977 227302 http://www.altanet.org ipons@dtgna.altanet.org ---------------------------------------