Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2003
    Posts
    2,296

    Unanswered: export error using 9.2 EXP on 8.1.7

    I can not figure out why I am getting this error.
    I thought you could use a 9.* Exp utility on an older Oracle version ...

    I am not specifying table-names, all I am doing is exporting with OWNER=PLATFORM


    command-line:
    owner=platform direct=Y compress=Y consistent=Y feedback=100000 file=db01_platform.dmp log=db01.log

    Code:
    Export: Release 9.2.0.1.0 - Production on Thu Jul 31 12:43:48 2003
    
    Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.
    
    
    Connected to: Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
    With the Partitioning option
    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_Duck
    you can lead someone to something but they will never learn anything ...

  2. #2
    Join Date
    Jul 2003
    Posts
    2,296
    found the answer:

    Export oldest with oldest exp version, then import with newest exp version.

    Shows you what I know (which is little, but I can look it up!)
    - The_Duck
    you can lead someone to something but they will never learn anything ...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •