Re: exp/imp and NLS

From: Terminator <kramakrishnabest_at_gmail.com>
Date: 29 Mar 2005 04:53:09 -0800
Message-ID: <1112100789.292343.33940@f14g2000cwb.googlegroups.com>

His source 9i database is AL32UTF8. He is exporting this to 8i database

which does not recognize AL32UTF8 when running 8i imp against the dump file.

U said above line yes, As actually he has taken the export from Oracle 9i
then he is trying to import into oracle 8i. So as per the metalink doc http://metalink.oracle.com/metalink/plsql/ml2_documents.showFrameDocument?p_database_id=NOT&p_id=237593.1 This says that we can use the

"Practically this means that in 99% of the cases you can use UTF8 instead of AL32UTF8 without any problem. There are only a few situations where Unicode 3.2 is already used on client side."

so please use the setting below before executing the export $NLS_CHAR=UTF8 And then import to 8i database Received on Tue Mar 29 2005 - 06:53:09 CST