hi all,
i used the below statements, but i now got another
error ....ORA-12712, which says new character set
must be a superset of the old cahracter set.
pls can u give a clue to what could be the problem.
i actually want to change my db character set from
US7ASCII TO WE8ISO8859P1 .
THANK YOU ALL.
--- David Kerr-Wilson <David.Kerr-[Email Address Removed] 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] |Sent: 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] To subscribe: send a blank email to
> oracledba-[Email Address Removed] By using this list you agree to these
> terms:http://www.lazydba.com/legal.html
>
>
> --------
> 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] To subscribe: send a blank email to
> oracledba-[Email Address Removed] By using this list you agree to these
> terms:http://www.lazydba.com/legal.html
>
__________________________________
Do you Yahoo!?
Get better spam protection with Yahoo! Mail.
http://antispam.yahoo.com/tools
Oracle LazyDBA home page