DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: EXP Error

  1. #1
    Join Date
    Oct 2002

    EXP Error

    Hello all..

    I was trying to EXP 817 DB using 901 EXP utility, since my Target DB will be 901.

    Its working Fine when i use 817 EXP utility. But when i use 901 EXP tool, this is what i get.

    C:\Or901Home\BIN>exp system/password@lyris buffer=10000 file=c:\backup\lyris\lyris901.dmp log=c:\backup\lyris\lyris.log full=y consistent=y

    Export: Release - Production on Fri Jul 18 09:06:15 2003

    (c) Copyright 2001 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


    Any one has any idea why this is happening ?. Any help is appreciated


  2. #2
    Join Date
    Sep 2000
    Chennai, India
    Use 817 exp utility to export from 817 database. So also, use 9i imp utility to import the 817 exp dump file into the 9i database.


  3. #3
    Join Date
    Dec 2000
    To perform EXPORT backup using 9i exp utility for an 8i database it is not possible.

    1. Use the export utility of Oracle 8.1.7 or still lower version exp utility and import using 9i import utility.
    2. If your upgrading to 9i, go for oracle 9i rel 2
    i.e, which is recent version. Since is a bug product.

    You cannot perform EXPORT Backup using higher version EXP utility to a database of Lower version.

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.