Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2007

    Unanswered: HELP - Export/Import with version 8.05

    I'm running Oracle 8.05 with Windows 2003 Server
    From Client i'm running 0racle 9i with Windows XP Profeshional
    from command promt of client, i want export database server, but i has som error:
    C:\>exp sys/sys@newtnama file=D:\Backup\test.dmp owne
    r = test

    Export: Release - Production on Mon Mar 5 11:39:55 2007

    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

    please help me

  2. #2
    Join Date
    Jan 2004
    Croatia, Europe
    Provided Answers: 5
    Export must be done using lower export utility version. In your case, it is 8.1.7. As you don't have it installed on a client, take 8.1.7 installation CD and install only utilities you need (no need to install the whole product).

    Once export is done, you can import it into another 8.1.7 database (using its import utility) or into 9i using 9i's import utility.

    Generally speaking, export data using export utility of the lower database version, and import it using import utility of the target database.

Posting Permissions

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