| EXP utility problem with Oracle versions [message #146425] |
Thu, 10 November 2005 06:27  |
nitesh_rana
Messages: 5
Registered: March 2005
|
Junior Member |
|
|
Hi,
I have Oracle 8i 8.1.7 server installed on the server machine.
I have Oracle 9.2.0 client installed on my machine. I tried to export a schema using the export utility installed on my machine.
I get the following error message:
EXP-00056: ORACLE error 942 encountered
ORA-00942: table or view does not exist
EXP-00000: Export terminated unsuccessfully
Is it because I have used export utility of Oracle 9.2.0 client installed on my machine. Please confirm this and if possible can anyone highlight on the exact reasons for the above error.
Thanks & regards,
Nitesh Rana.
|
|
|
|
| Re: EXP utility problem with Oracle versions [message #146431 is a reply to message #146425] |
Thu, 10 November 2005 06:55  |
 |
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
Search the forum before posting.
These are discussed many many times.
Long story short, there are two options.
1.) use the lower version's of export tool to export data (8.1.7)
and same lower version of import tool to import data (8.1.7)
or
2.) you need to install the 9.2 version of export/import views in a 8i database.
from your 9.2 installation , login to the 8i database as SYS user and run the script catexp.sql
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
