Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Drop database in Oracle 9i

570672Feb 22 2008 — edited Feb 23 2008

I have a situation wherein I need to drop a database and recreate the database using a different NLS_characterset. The software (Cognos) I am trying to install will not accept the default characterset and only prefers in a particular format. I am using Oracle 9i. I would like to know how I could drop the database and recreate a new one database with the correct characterset.
Also, can you advise me as to how to create the database using NLS_CHARACTERSET with either UTF-8 or AL32UTF8? Also, is there a way I can change this parameter in my existing database to the value I need. I need to address this immediately. Can the experts on this forum please guide me.

Message was edited by:
user567669

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 22 2008

Added on Feb 22 2008

#database-installation

2 comments

1,086 views