ORA00942 error when trying to export user tables
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: ORA00942 error when trying to export user tables

  1. #1
    Join Date
    May 2001
    Posts
    285

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

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    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
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    May 2001
    Posts
    285
    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.

  4. #4
    Join Date
    Jan 2001
    Posts
    3,131
    Why don't you just do a schema level export?

    MH
    I remember when this place was cool.

  5. #5
    Join Date
    May 2001
    Posts
    285
    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

  6. #6
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    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
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  7. #7
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    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
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  8. #8
    Join Date
    Jan 2001
    Posts
    3,131
    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
  •  



Click Here to Expand Forum to Full Width