| EXPproblem through DBLINK [message #141870] |
Wed, 12 October 2005 10:22  |
vqd2697
Messages: 36
Registered: October 2004
|
Member |
|
|
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. Please help out
TIGER 163 : exp
Export: Release 10.1.0.3.0 - Production on Wed Oct 12 10:27:38 2005
Copyright (c) 1982, 2004, Oracle. All rights reserved.
Username: TEST@PROD
Password:
Connected to: Oracle8i Enterprise Edition Release 8.1.7.0.0 - 64bit Production
With the Partitioning option
JServer 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
[Updated on: Wed, 12 October 2005 10:31] Report message to a moderator |
|
|
|
| Re: EXPproblem through DBLINK [message #142375 is a reply to message #141870] |
Fri, 14 October 2005 07:09  |
Frank Naude
Messages: 4587
Registered: April 1998
|
Senior Member |
|
|
The export utility is looking for 10g's export views in your 8i database.
Try one of the following:
- Upgrade the DB to 10g
- Downgrade the client to 8i
- Run Oracle 8i's catexp.sql against the 10g database
Best regards.
Frank
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
