Home » RDBMS Server » Server Utilities » Error while importing dump (Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 )
Error while importing dump [message #427387] Thu, 22 October 2009 06:02 Go to next message
adiga
Messages: 6
Registered: August 2007
Junior Member
Hello All,

We have a dump provided by our client which we are unable to import into our 10g database locally.

Following is an extract of the export log:
=============================================================
Export: Release 9.2.0.4.0 - Production on Wed Oct 21 10:46:58 2009

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Export done in US7ASCII character set and AL16UTF16 NCHAR character set
server uses WE8MSWIN1252 character set (possible charset conversion)

About to export specified users ...
==============================================================

When we try to import this into our local DB, it gives an error and stops:
==============================================================

Export file created by EXPORT:V09.02.00 via conventional path

Warning: the objects were exported by SYSTEM, not by you

import done in US7ASCII character set and AL16UTF16 NCHAR character set
import server uses WE8ISO8859P1 character set (possible charset conversion)
IMP-00003: ORACLE error 922 encountered
ORA-00922: missing or invalid option
IMP-00000: Import terminated unsuccessfully
===============================================================

The source database is 11g but the export utility used is 9.2.0.4 as seen above. And the destination DB is 10.2.0.1.0

Can anyone please give us some ideas on this?

Thanks in advance,
Pradeep
Re: Error while importing dump [message #427389 is a reply to message #427387] Thu, 22 October 2009 06:19 Go to previous messageGo to next message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Source: 11g
Target: 10g
Exp utility used: 9i -> why?!?

As a rule of thumb: export should be done by source database version's EXP utility. Import should be done by target database version's IMP utility.

However, as your source is 11g, I'm not sure whether 10g IMP is capable of reading an export file created by 11g EXP (didn't try it).

Perhaps you could try to export and import with 10g EXP/IMP utilities? Or, possibly, wait for another opinion (i.e. someone who had done that before).
Re: Error while importing dump [message #427511 is a reply to message #427387] Fri, 23 October 2009 00:23 Go to previous messageGo to next message
adiga
Messages: 6
Registered: August 2007
Junior Member
Thanks for the reply.

We cannot load a dump created from a higher version of the export to a lower version DB. Hence the client DBA used the v9 export on a 11g DB.

Anyway, as you said, it might still be because of version differences. We are now upgrading our 10g to 11g. So, this problem should not arise then.

thanks
Re: Error while importing dump [message #427601 is a reply to message #427511] Fri, 23 October 2009 08:07 Go to previous messageGo to next message
joy_division
Messages: 4640
Registered: February 2005
Location: East Coast USA
Senior Member
adiga wrote on Fri, 23 October 2009 01:23

We cannot load a dump created from a higher version of the export to a lower version DB. Hence the client DBA used the v9 export on a 11g DB.


Why didn't they use the 10g export when that is the version of the database you have?
Re: Error while importing dump [message #436000 is a reply to message #427387] Sun, 20 December 2009 23:53 Go to previous messageGo to next message
anwar786
Messages: 25
Registered: May 2009
Location: bangalore
Junior Member
the error is because you tried to imprt using different fromuser othere than system so try importing using fromuser=system
it shud work
Re: Error while importing dump [message #436014 is a reply to message #436000] Mon, 21 December 2009 01:43 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No, the error does not come from that, who say OP wants to import SYSTEM objects (that is what FROM keyword indicates)?

The message:
Quote:
Warning: the objects were exported by SYSTEM, not by you

is just a warning saying the user that is importing is not the user that exported. I never understood why Oracle put this message it has no interest (or maybe in case of VPD).

Regards
Michel
Previous Topic: Problem while importing data...
Next Topic: External Tables - Tab Separated Values
Goto Forum:
  


Current Time: Sat Dec 03 19:54:23 CST 2016

Total time taken to generate the page: 0.14278 seconds