Export/Import from 8I to 7.3.3
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Export/Import from 8I to 7.3.3

  1. #1
    Join Date
    Jan 2000
    Location
    Adelphi, Md. USA
    Posts
    28
    Hi,

    I am on Win NT Oracle 8I version 8.1.5 and want to export/import to another machine with Oracle 7.3.3. Question is on the 8i server, if I run Catexp7.sql to create the views so that I can create the export file that 7.3.3 will read, I am wondering if that will mess-up my export/import utilities on 8i version 8.1.5? And, do I have to goback on my 8i server and run catexp to get back exp/imp for 8i?

    Thanks

  2. #2
    Join Date
    Apr 2000
    Location
    Edison, NJ
    Posts
    759
    Run catexp.sql (for v8i) on the 8i db and catexp.sql (for v7.3.3) on the 7.3.3 db. Then export from v8i and import into v7.3.3.

  3. #3
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    I dont think you can do that nor export from 8i then import into 7.3.3

  4. #4
    Join Date
    Apr 2000
    Location
    Edison, NJ
    Posts
    759
    hmm... as far as I know, the correct catexp.sql has to be run against the db in question. Of course, problems can arise if importing an 8i on v7, since it's like a downgrade, and esp. if the 8i db contains LONG datatype.

  5. #5
    Join Date
    Apr 2000
    Posts
    126

    Wink Export/Import from 8I to 7.3.3

    You need to use the version 7 Export Utility with the catexp7.sql - created views installed to export the version 8i database.

    See the Migration Guide and Oracle 8i Utilities for more information about performing a version 7 export from version 8i.

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