ORA00942 error when trying to export user tables

[elaine3839]

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

[marist89]

Your client version is different than your server version. For example, your server is 8.1.7.0 and your client might be 9.2.0.1.

[elaine3839]

That's exactly right! So I have to use a 8.1.7 client to perform the export because that's an 8i server?

Originally posted by marist89
Your client version is different than your server version. For example, your server is 8.1.7.0 and your client might be 9.2.0.1.

[Mr.Hanky]

Why don't you just do a schema level export?

MH

[elaine3839]

Are you saying if I do the schema level export then I won't get the error caused by running export using 9i client against a 8i server?

I don't mind doing schema level export, although user level export should be enough in this case.

As long as I can get it work, I am happy

Originally posted by Mr.Hanky
Why don't you just do a schema level export?

MH

[marist89]

Originally posted by elaine3839
That's exactly right! So I have to use a 8.1.7 client to perform the export because that's an 8i server?

That's the easiest way to do it.

[marist89]

Originally posted by Mr.Hanky
Why don't you just do a schema level export?

MH

What, exactly, is the difference between a schema level export and a user exporting their own objects?

[Mr.Hanky]

Originally posted by marist89
What, exactly, is the difference between a schema level export and a user exporting their own objects?

You tell me, you're the "Genius".

Actually, the way this is phrased it sounded like elaine was exporting all the tables via...

TABLES=(blah, blah_blah, boxters_r_4_yuppies) ect...

I just a schema level would be easier.

MH