| Error while importing dump [message #427387] |
Thu, 22 October 2009 06:02  |
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 #427511 is a reply to message #427387] |
Fri, 23 October 2009 00:23  |
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 |
joy_division
Messages: 4963
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 #436014 is a reply to message #436000] |
Mon, 21 December 2009 01:43 |
 |
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
|
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
