DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2001

    oracle 9i export related error


    I am trying to export an oracle8i schema from oracle9i db server. The error that I am getting is given below. Pls mention why am I getting this error and what is the workaround for this problem.

    thanking you in advance.

    Parijat Paul

    G:\Backup\indiadbbackups\archive\indqadb\myname>exp system/xyz@abc file=qwerty log=qwerty owner= myname

    Export: Release - Production on Thu Nov 4 17:27:14 2004

    Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

    Connected to: Oracle8i Enterprise Edition Release - Production
    With the Partitioning option
    JServer Release - Production
    EXP-00056: ORACLE error 942 encountered
    ORA-00942: table or view does not exist
    EXP-00000: Export terminated unsuccessfully


  2. #2
    Join Date
    Nov 2002
    Geneva Switzerland
    You should use the 8i export and 9i import.

  3. #3
    Join Date
    Dec 2001

    well, can i run the 8i export from the 9i db? Our backups were earlier stored on a machine which has been upgraded to 9i from 8i as such none of the exports are running. All our dbs are 8i except the one which has been upgraded to 9i and this machine which has oracle 9i has the scheduler set to export all the the schemas from the other 8i dbs. This 9i machine has a separate drive to store the export dump files and the other 8i dbs do not have space to store the export dumps. As such I can not reschedule the exports from the 8i machines.
    Is there any work around?


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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.