Home » RDBMS Server » Server Utilities » exp related (Oracle 10g, 9i)
exp related [message #379017] Sat, 03 January 2009 23:27 Go to next message
Messages: 48
Registered: June 2007
Location: Bangladesh
I am using Oracle at present. I have to export data from Oracle 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 - Production on Sun Jan 4 11:21:27 2009

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

Connected to: Oracle9i Release - Production
JServer Release - 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
Messages: 24958
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: 63911
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

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

Current Time: Fri Oct 21 17:44:33 CDT 2016

Total time taken to generate the page: 0.16372 seconds