| EXP-00056 Error while Exporting [message #70639] |
Wed, 10 July 2002 06:07  |
Minal Nemani
Messages: 1
Registered: July 2002
|
Junior Member |
|
|
Hi All,
I just intalled Personal Oracle 9i on Windows NT from the Oracle website. In our company we have Oracle 9i for Solaris also. I tried to export schema from the solaris system, using the exp executable from the Windows NT machine. Following are the steps and the errors which I have received.
/**************************************************/
C:>exp
Export: Release 9.2.0.1.0 - Production on Tue Jul 9 14:44:52 2002
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Username: pin1/pin1@dbdev
Connected to: Oracle9i Enterprise Edition Release 9.0.1.0.0 - Production
With the Partitioning option
JServer Release 9.0.1.0.0 - Production
Enter array fetch buffer size: 4096 >
Export file: EXPDAT.DMP >
(2)U(sers), or (3)T(ables): (2)U >
Export grants (yes/no): yes >
Export table data (yes/no): yes >
Compress extents (yes/no): yes >
EXP-00056: ORACLE error 942 encountered
ORA-00942: table or view does not exist
EXP-00000: Export terminated unsuccessfully
C:>
/************************************************/
Can someone will please be able to help me solve this. I looked all possible documentation, but cannot find any related solutions.
Thanks
|
|
|
|
| Re: EXP-00056 Error while Exporting [message #70641 is a reply to message #70639] |
Wed, 10 July 2002 06:23  |
Grant
Messages: 578
Registered: January 2002
|
Senior Member |
|
|
|
Your windows version is 9.2 and the solaris is 9.0. You might try using export on the solaris machine then ftp the file to your client and import. You should be able to do this the way you tried. Check Meta Link on "export +matrix" and see if it should work.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
