Question:
I
tried to export the table from client database 8.1.7
using DBLINK from our database 10.1.0.3 and got this
error "EXP-00056: ORACLE error 942 encountered".
Please help out.
Export: Release 10.1.0.3.0 - Production on Wed Oct
12 10:27:38 2005
Copyright © 1982, 2004, Oracle. All rights reserved.
Connected to: Oracle8i Enterprise Edition Release
8.1.7.0.0 - 64bit Production
Enter array fetch buffer size: 4096 >
Export file: expdat.dmp > test.dmp
(2)U(sers), or (3)T(ables): (2)U > 3
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
Answer by Edward Stoever:
I
have always used exp as a single command, not
interactively. It is claiming the table does not
exist, but I don't see it asking for a table - yet.
(weird)
Why not try it as a single
command.... like this:
exp scott/tiger file=emp.dmp
tables=(emp,dept)
I think
that you are breaking the second rule there, and you
should be exporting using an 8.1.7 client.
The Oracle
documentation notes:
Whenever you are moving data
between different releases of the Oracle database,
the following basic rules apply:
* The Import utility and the database to which data
is being imported (the target database) must be the
same version. * The version of
the Export utility must be equal to the earliest
version of the source or target database.
For example, to create an export file for an import
into a later release database, use a version of the
Export utility that is equal to the source database.
Conversely, to create an export file for an import
into an earlier release database, use a version of
the Export utility that is equal to the version of
the target database.
|
|
|
Get the Complete
Oracle Utility Information
The landmark book
"Advanced Oracle
Utilities The Definitive Reference" contains over 600 pages of
filled with valuable information on Oracle's secret utilities.
This book includes scripts and tools to hypercharge Oracle 11g
performance and you can
buy it
for 30% off directly from the publisher.
|
|
|
|