Error during import using Impdp [message #297304] |
Thu, 31 January 2008 01:26 |
kamragulshan
Messages: 66 Registered: May 2005 Location: Delhi
|
Member |
|
|
Hi Experts,
I am trying to import the schema using impdp but it throws the below error:
ORA-31694: master table "SYSTEM"."SYS_IMPORT_SCHEMA_01" failed to load/unload
ORA-02354: error in exporting/importing data
ORA-39774: parse of metadata stream failed with the following error:
LPX-00217: invalid character 0 (U+0000
ORA-39014: One or more workers have prematurely exited.
After troubleshooting, i find that the cause of the above error is because of difference in NLS_NCHAR_CHARACTERSET.
The values of NLS_NCHAR_CHARACTERSET of both databases:
Export database: UTF8
Import database: AL16UTF16
Please confirm that is this the reason for the import failure.
Now, Is there any possibility to change the existing characterset from AL16UTF16 to UTF8?
I got the below solution from internet:
Execute the following commands in sqlplus connected as "/ AS SYSDBA":
SHUTDOWN IMMEDIATE;
STARTUP MOUNT;
ALTER SYSTEM ENABLE RESTRICTED SESSION;
ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;
ALTER SYSTEM SET AQ_TM_PROCESSES=0;
ALTER DATABASE OPEN;
ALTER DATABASE NATIONAL CHARACTER SET UTF8;
SHUTDOWN IMMEDIATE;
Is this the correct way to change the charactset? What would be the impact of changing the characterset and is there any data loss? Or Do we need to recreate the database again, as it would be quite difficult as other schemas are exist and users are accessing the same.
Please confirm my analysis and suggest the best way to solve the problem.
Thanks in Advance
Gulshan
|
|
|
|
|
|
|
|
Re: Error during import using Impdp [message #297542 is a reply to message #297304] |
Fri, 01 February 2008 05:11 |
kamragulshan
Messages: 66 Registered: May 2005 Location: Delhi
|
Member |
|
|
Yes Michel, the problem was not because of different characterset.
I have tried a lot on internet but did not get any clue.
Is there any other cause of this error.
How can i come out of this error.
Please suggest.
Thanks
Gulshan
|
|
|
|
|
|