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!

NVARCHAR2 with size more than 2000 in 9i

skurup2Mar 4 2003 — edited Mar 5 2003

Is it possible to create a table with NVARCHAR2 size bigger than 2000. The character set of the 9i database are
NLS_CHARACTERSET :- US7ASCII
NLS_NCHAR_CHARACTERSET :- AL16UTF16
This generates ORA-00910 error while creating the table.

I was able to do this after creating the database in UTF8 (NLS_CHARACTERSET -UTF8 & NLS_NCHAR_CHARACTERSET - UTF8)

But I need to create this table on an existing 9i production database without impacting existing applications. This database uses
NLS_CHARACTERSET :- US7ASCII
NLS_NCHAR_CHARACTERSET :- AL16UTF16
Don't want to change the entire database character set.

Any help will be appreciated
- sreeni

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 2 2003

Added on Mar 4 2003

#general-database-discussions

9 comments

1,154 views