Import error ORA-31694 [message #623887] |
Mon, 15 September 2014 23:16 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
Tlg13team
Messages: 100 Registered: June 2008 Location: MGL
|
Senior Member |
|
|
hi all,
I exported a table from Oracle 11.2.0.3.0 (used to expdp) then import it (used to impdp) to Oracle 11.2.0.1.0 but given error below:
Quote:
Import: Release 11.2.0.1.0 - Production on Tue Sep 16 11:04:57 2014
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-39002: invalid operation
ORA-31694: master table "SYSADM"."SYS_IMPORT_FULL_01" failed to load/unload
ORA-02354: error in exporting/importing data
ORA-39774: parse of metadata stream failed with the following error:
LPX-00007: unexpected end-of-file encountered
How to solve this issue?
I used version paramater with expdp but no difference on impdp process.
|
|
|
|
Re: Import error ORA-31694 [message #623889 is a reply to message #623888] |
Mon, 15 September 2014 23:27 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
Tlg13team
Messages: 100 Registered: June 2008 Location: MGL
|
Senior Member |
|
|
I did below command but still received above error.
expdp ADM/ADM@SID DIRECTORY=EXP_DIR TABLES=NUMBER dumpfile=DB_1.dmp logfile=LOG_`date +"%Y-%m-%d-%H%M"`.log COMPRESSION=ALL VERSION=11.2.0.1.0
|
|
|
Re: Import error ORA-31694 [message #623895 is a reply to message #623889] |
Tue, 16 September 2014 01:34 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68675 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Do you really have a table named NUMBER?
This is a reserved word and should NEVER be used.
SQL> create table number (id int);
create table number (id int)
*
ERROR at line 1:
ORA-00903: invalid table name
This maybe the root of your error but I have no 11.2.0.1 to test; try to import it in the original database to check the file.
Are you importing in the same OS you have exported?
|
|
|