This content has been marked as final. Show 4 replies
Pl post the exact error message that the csalter code produced.
Are you using any NCHAR, NVARCHAR2 or NCLOB datatypes ? The national characterset is only used for these datatypes.
How big is the database ? How much down time can you afford ?
One simple option is a full export, drop the database, re-create the database with the appropriate charactersets, followed by a full import.
Sorry that is not actually an error, it shows a message like this
"Checking or Converting phase did not finish successfully
No database (national) character set will be altered
CSALTER finished unsuccessfully"
At Present, character datatype for nchar character set is varchar2.However, I need actually it to be nvarchar how can it be changed??
Database is about 4.5GB which is a complex data, I just can't go with import,drop and re-create the database which no doubt gives me tons of errors which I can't handle.
So could you please tell me how can I do that.
There is no reason to touch the national (NVARCHAR2) character set, if you want to change the database (VARCHAR2) character set. csalter.plb will not touch the national character set unless you unnecessarily scanned the national data types by specifying the parameter TONCHAR. If you just want to change the database character set, drop the CSMIG schema, recreate it and scan the normal character columns by specifying TOCHAR only. Then, csalter.plb will not complain about the national character set anymore.