| ORA-00942 Oracle error [message #73330] |
Fri, 26 March 2004 12:11  |
Raquel
Messages: 46
Registered: July 2003
|
Member |
|
|
Hello,
I have Oracle 9i installed on my desktop
I have been creating tables and bulk loading records into those tables on a database located on a server that runs Oracle 8i
When I tried to export the tables and records using SQLLDR I got this message: EXP-0056: ORACLE error 942 encountered ORA-00942: table or view does not exist EXP-00000: Export terminated unsuccessfully.
Is there a workaround to this problem.
|
|
|
|
| Re: ORA-00942 Oracle error [message #73333 is a reply to message #73330] |
Mon, 29 March 2004 01:20  |
Frank Naude
Messages: 4587
Registered: April 1998
|
Senior Member |
|
|
Hi,
One cannot export records from a table with SQLLDR, so I assume you mean the export utility (exp).
Run ?/rdbms/admin/catexp.sql as SYS and retry.
Best regards.
Frank
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
