ORA00942 error when trying to export user tables

Printable View

08-21-2003, 11:47 AM
elaine3839

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!!!
08-21-2003, 11:58 AM
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.
08-21-2003, 11:59 AM
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?

Quote:

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.
08-21-2003, 12:06 PM
Mr.Hanky

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

MH
08-21-2003, 12:20 PM
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 :D

Quote:

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

MH
08-21-2003, 01:49 PM
marist89

Quote:

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.
08-21-2003, 01:50 PM
marist89

Quote:

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?
08-21-2003, 01:57 PM
Mr.Hanky

Quote:

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