-
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!!!
-
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.
Jeff Hunter
-
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.
-
Why don't you just do a schema level export?
MH
I remember when this place was cool.
-
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
-
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.
Jeff Hunter
-
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?
Jeff Hunter
-
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
I remember when this place was cool.
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
|