-
ORA00942 error when trying to export user tables
Oracle server is 8.1.7
OS is win2K
I was trying to export all tables belong to an user (eg. exp_user) and has granted create session to that user. Plus, I have run catalog.exe to create the views needed. I was trying to do this for a remote server -- run export locally, and write data from a remote oracle database into a local export file.
However, when I do
exp exp_user/passwd@ora_instance parfile=par_export.txt
I got
Connected to: Oracle8i Release 8.1.7.0.0 - Production
JServer Release 8.1.7.0.0 - Production
EXP-00056: ORACLE error 942 encountered
ORA-00942: table or view does not exist
EXP-00000: Export terminated unsuccessfully
the parfile looks like this --
file=oradev1.dmp
indexes=y
rows=y
log=oradev1_exp.log
direct=y
So how do I know which table/view it refers to in 942 error?
Thanks!!!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|