Just change the character set in svrmgrl. The following example
converts to ISO standard, just change the WE8ISO859P1 string.

SHUTDOWN IMMEDIATE;
STARTUP MOUNT;
ALTER SYSTEM ENABLE RESTRICTED SESSION;
ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;
ALTER DATABASE OPEN;
ALTER DATABASE CHARACTER SET WE8ISO8859P1;
ALTER DATABASE NATIONAL CHARACTER SET WE8ISO8859P1;
SHUTDOWN IMMEDIATE;
STARTUP;


|-----Original Message-----
|From: Ayodeji Orimisan [mailto:[Email Address Removed] Thursday, February 26, 2004 11:04 PM
|To: LazyDBA.com Discussion
|Subject: how do i drop an oracle DB (8i on UNIX) .....urgent
|
|
|
|i created a database with an american character set,
|but i ought to have created it with west european characterset.
|
|how do i drop the database i already created.
|
|thankx.
|
|__________________________________
|Do you Yahoo!?
|Get better spam protection with Yahoo! Mail.
http://antispam.yahoo.com/tools

--------
Get today's cartoon: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] using this list you agree to these
terms:http://www.lazydba.com/legal.html

Oracle LazyDBA home page