Home » RDBMS Server » Server Utilities » Import error ORA-31694 (Oracle, 11g R2, solaris 5.10)
Import error ORA-31694 [message #623887] Mon, 15 September 2014 23:16 Go to next message
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 #623888 is a reply to message #623887] Mon, 15 September 2014 23:18 Go to previous messageGo to next message
BlackSwan
Messages: 26733
Registered: January 2009
Location: SoCal
Senior Member
you must use lower version expdp or set VERSION to be lower version value
Re: Import error ORA-31694 [message #623889 is a reply to message #623888] Mon, 15 September 2014 23:27 Go to previous messageGo to next message
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
Michel Cadot
Messages: 67369
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?

Previous Topic: SQL*Loader-510: Physical record in data file is longer than the maximum(20971520)
Next Topic: SQLLDR retaining DB column value
Goto Forum:
  


Current Time: Thu Sep 24 06:48:25 CDT 2020