Export from 7.3 with 8.1.7 client
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 12

Thread: Export from 7.3 with 8.1.7 client

  1. #1
    Join Date
    Jul 2004
    Posts
    9

    Export from 7.3 with 8.1.7 client

    Can I export a 7.3.3 database with a 8.1.7 export utility? Theoretically it
    should work.

    EXP-00008: ORACLE error 942 encountered
    ORA-00942: Tabelle oder View nicht vorhanden
    EXP-00024: Export views not installed, please notify your DBA
    EXP-00000: Export terminated unsuccessfully

    But why am I getting these error messges? What scripts need to be run to
    solve this problem?

    Oracle 7.3: Solaris 2.5;
    Oracle 8.1.7: Win2k;

  2. #2
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    3,968
    Have you done a metalink search on this? There are views that need to be installed to import/export from one version to another.

    If you are upgrading a 7.3.4 database to 8i, why don't you just use the 7.3.4 client to do the export?

  3. #3
    Join Date
    Sep 2001
    Location
    Makati, Philippines
    Posts
    857
    was it catexp7.sql found in $ORACLE_HOME/rdbms/admin?

  4. #4
    Join Date
    Jul 2004
    Posts
    9

    export from 7.3 to 8.1.

    with catexp7.sql i can export from 8.1 to 7.3, but i want export from 7.3 to 8.1. I try make connect from 8.1. to 7.3:

    exp userid=user/passwd@ora7.3 file=... log=... tables=(xxx) ang get error:
    EXP-00008: ORACLE error 942 encountered
    ORA-00942: Tabelle oder View nicht vorhanden
    EXP-00024: Export views not installed, please notify your DBA
    EXP-00000: Export terminated unsuccessfully

    Oracle v 7.3 has a export maximum size 2Gb. I have data>2Gb :(

  5. #5
    Join Date
    Sep 2001
    Location
    Makati, Philippines
    Posts
    857
    I can't download the COMPATIBILITY MATRIX regarding EXPORT/IMPORT between different oracle versions/o.s. pls have reference on it.

  6. #6
    Join Date
    Sep 2001
    Location
    Makati, Philippines
    Posts
    857
    is this just a one time process? or you are planning to migrate to 8i?
    see gandolf's suggestion.

  7. #7
    Join Date
    Sep 2001
    Location
    Makati, Philippines
    Posts
    857
    see this not in metalink: Note:132904.1
    here's an excerpt:
    Matrix 2: Which EXPORT utility to use when importing into an Oracle8 or a higher database release (always use IMPORT utility of the target database): +-----------+------------------------------------------------------+ | EXPORT | IMPORT into: | | from +--------+--------+--------+--------+--------+---------+ | \/ | 8.1.5 | 8.1.6 | 8.1.7 | 9.0.1 | 9.2.0 | 10.1.0 | +-----------+--------+--------+--------+--------+--------+---------+ | 5.x 1) 2)| EXP5x | EXP5x | EXP5x | EXP5x | EXP5x | EXP5x | | 6.x 2)| EXP6x | EXP6x | EXP6x | EXP6x | EXP6x | EXP6x | | 7.x 3)| EXP7x | EXP7x | EXP7x | EXP7x | EXP7x | EXP7x | +-----------+--------+--------+--------+--------+--------+---------+ | 8.0.3 | EXP803 | EXP803 | EXP803 | EXP803 | EXP803 | EXP803 | | 8.0.4 | EXP804 | EXP804 | EXP804 | EXP804 | EXP804 | EXP804 | | 8.0.5 | EXP805 | EXP805 | EXP805 | EXP805 | EXP805 | EXP805 | | 8.0.6 | EXP806 | EXP806 | EXP806 | EXP806 | EXP806 | EXP806 | +-----------+--------+--------+--------+--------+--------+---------+ | 8.1.5 | EXP815 | EXP815 | EXP815 | EXP815 | EXP815 | EXP815 | | 8.1.6 | EXP815 | EXP816 | EXP816 | EXP816 | EXP816 | EXP816 | | 8.1.7 | EXP815 | EXP816 | EXP817 | EXP817 | EXP817 | EXP817 | +-----------+--------+--------+--------+--------+--------+---------+ | 9.0.1 | EXP815 | EXP816 | EXP817 | EXP901 | EXP901 | EXP901 | | 9.2.0 | EXP815 | EXP816 | EXP817 | EXP901 | EXP920 | EXP920 | +-----------+--------+--------+--------+--------+--------+---------+ | 10.1.0 4)| EXP815 | EXP816 | EXP817 | EXP901 | EXP920 | 4) | +-----------+--------+--------+--------+--------+--------+---------+

  8. #8
    Join Date
    Jul 2004
    Posts
    9

    export util

    database is using in industrial system and developer's firm not permit migrate to oracle>7.3. i am wanted make full export/incremental export/cummulative export for save our data. but export file size not more 2Gb and i want use exp from 8.1.

  9. #9
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    The rule is, when going from version X to version Y:
    - export with the lower version of X and Y, from db X
    - import with version Y, into db Y
    (see Tom Kyte 1-on-1 p.353)

    Added later: From the manual:
    Using a Higher Version Export
    Attempting to use a higher version of Export with an Oracle Server often produces the following error:
    EXP-37: Database export views not compatible with Export utility
    EXP-0: Export terminated unsuccessfully
    The error occurs because views that the higher version of Export expects are not present. To avoid this problem, use the version of the Export utility that matches the Oracle Server.
    Sounds like you will have to break up the export job into pieces - generating the TABLES= statements from DBA_TABLES.
    Last edited by DaPi; 10-08-2004 at 03:29 AM.

  10. #10
    Join Date
    Jul 2004
    Posts
    9

    export a 7.3.3 database with a 8.1.7 export utility

    I found solution for this problem:

    Make export:

    mknod export_pipe p
    chmod 666 export_pipe
    nohup split -b 1024m exp userid=user/passwd file=/..../export_pipe...

    Make import:

    mknod import_pipe p
    chmod 666 import_pipe
    nohup cat xaa xab xac>import_pipe&
    imp userid=user/passwd file=/.../import_pipe ignore=yes

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