| 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 #427389 is a reply to message #427387] |
Thu, 22 October 2009 06:19  |
Littlefoot
Messages: 9242
Registered: June 2005
Location: Croatia, Europe |
Senior Member |
|
|
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 |
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: 2883
Registered: February 2005
Location: NY |
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?
|
|
|
] 
Members
Search
Help
Register
Login
Home
