Transportable Tablespaces and NCHAR conversion.

From: <Prasada.Gunda_at_hartfordlife.com>
Date: Mon, 17 May 2004 10:57:19 -0400
Message-ID: <OF81CB1702.A61A47A5-ON85256E97.00520669-85256E97.005212A4@hartfordlife.com>

We are migrating our databases from 8i to 9i and would like to use transportable tablespaces for data/index tablespaces. Both 8i and 9i environments are on the same hardware platform(HP) and same the operating system(HP Unix).

On 8i environment, Both NLS_CHARACTERSET and NLS_NCHAR_CHARACTERSET are set to US7ASCII.
On 9i environment, NLS_CHARACTERSET set to US7ASCII and NLS_NCHAR_CHARACTERSET set to UTF8.
When I am doing TTS from 8i to 9i, I am getting the following error (please see the line with <====== for the error).

Imp log :

Connected to: Oracle9i Enterprise Edition Release 9.2.0.3.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.3.0 - Production

Export file created by EXPORT:V08.01.07 via conventional path About to import transportable tablespace(s) metadata... import done in US7ASCII character set and UTF8 NCHAR character set export server uses US7ASCII NCHAR character set (possible ncharset conversion)
IMP-00017: following statement failed with ORACLE error 19736:
"BEGIN sys.dbms_plugts.beginImport

('8.1.7.4.0',1,'1',NULL,'NULL',1508685,"
"103001,2); END;"

IMP-00003: ORACLE error 19736 encountered ORA-19736: can not plug a tablespace into a database using a different national character set <===========
ORA-06512: at "SYS.DBMS_PLUGTS", line 1797 ORA-06512: at "SYS.DBMS_PLUGTS", line 1636

I tried NLS_NCHAR_CHARACTERSET with AL16UTF16 and still gives the same problem. I understand that both environments should have the same CHAR and NCHAR set for the TTS to work. Database did not allow US7ASCII for NLS_NCHAR_CHARACTERSET in 9i environment.

What is the alternative other than changing NLS_NCHAR_CHARACTERSET on 8i environment.

Please let me know if anyone come across this situation and how to resolve this. I spent lot of time researching on the metalink but did not get relevant information.

Any thoughts or inputs are much appreciated.

Thanks.

Best Regards,
Prasad
860 843 8377

PRIVILEGED AND CONFIDENTIAL: This communication, including attachments, is for the exclusive use of addressee and may contain proprietary, confidential and/or privileged information. If you are not the intended recipient, any use, copying, disclosure, dissemination or distribution is strictly prohibited. If you are not the intended recipient, please notify the sender immediately by return e-mail, delete this communication and destroy all copies.

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Mon May 17 2004 - 09:56:21 CDT