Home » RDBMS Server » Server Utilities » exp related (Oracle 10g, 9i)
exp related [message #379017] Sat, 03 January 2009 23:27 Go to next message
rumman
Messages: 48
Registered: June 2007
Location: Bangladesh
Member
I am using Oracle 10.1.0.2.0 at present. I have to export data from Oracle 9.2.0.1. I am using command:

-----------------------------------------------------
exp abc/abc@abc file='e:/abc.dmp' full=y
-----------------------------------------------------

User 'abc' has DBA role.

I am getting errors:

---------------------------------------------
Export: Release 10.1.0.2.0 - Production on Sun Jan 4 11:21:27 2009

Copyright (c) 1982, 2004, Oracle. All rights reserved.


Connected to: Oracle9i Release 9.2.0.1.0 - Production
JServer Release 9.2.0.1.0 - Production
Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
EXP-00056: ORACLE error 942 encountered
ORA-00942: table or view does not exist
EXP-00000: Export terminated unsuccessfully
------------------------------------------------

Could anyone please tell me what the problem is.
Re: exp related [message #379018 is a reply to message #379017] Sat, 03 January 2009 23:48 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
>Could anyone please tell me what the problem is.
It might be better if you use the V9 export utility against the V9 database.
Re: exp related [message #379025 is a reply to message #379018] Sun, 04 January 2009 00:46 Go to previous message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It is not better, you MUST use V9 export utility.

The general rule is:
- export with the lowest version of the 2 databases
- import with the version of the target database

Regards
Michel
Previous Topic: Different date
Next Topic: ORA-31684 with datapump for sequences
Goto Forum:
  


Current Time: Thu Dec 08 16:32:43 CST 2016

Total time taken to generate the page: 0.10246 seconds