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!!!