Skip to Main Content
Forums

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!

ORA-31694: master table "SYSTEM"."SYS_IMPORT_SCHEMA_01" failed to load/unlo

603447Dec 6 2010 — edited Dec 8 2010
Need help... I am importing production export file by schema to QA using this command:

set oracle_sid=qadb
impdp system/manager DIRECTORY=DATAEXP PARALLEL=10 DUMPFILE=exp_prod_01.dmp,exp_prod_02.dmp,exp_prod_03.dmp,exp_prod_04.dmp,exp_prod_05.dmp,exp_prod_06.dmp,exp_prod_07.dmp,exp_prod_08.dmp,exp_prod_09.dmp,exp_prod_10.dmp schemas=qaschema logfile=imp.log exclude=statistics

here is the error shown on the imp.log

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-00231: invalid character 47 ('/') found in a Name or Nmtoke
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 5 2011
Added on Dec 6 2010
#11g, #database, #general-database-discussions, #oracle, #windows
5 comments
10,351 views