Results 1 to 7 of 7
  1. #1
    Join Date
    Feb 2002
    Location
    San Francisco, CA
    Posts
    441

    Exclamation Unanswered: Urgent! - Dump files!

    Hello,
    I really need this question answered quickly -

    The problem is, I have a customer with 7.3 alpha, and we use 9i intel. Also I have a copy of 8.0.5.0.0 and we need to dump files from the later version (preferably 9i) and imp it into 7.3

    My question therefore is; can imp73 read oracle 8.0.5.0.0 or 9i exp files (is there some sort of compatibility mode?)?

    Oh, and using the older version of exp on the newer database won't work as they are for differing architechures (intel/alpha) and i don't have a 7.3 intel licence).
    Also using CSV or other flat files is not an option - the files must be able to be imported using imp73?

    Help is much appreciated!
    Last edited by rhs98; 06-26-02 at 10:43.

  2. #2
    Join Date
    Apr 2001
    Location
    Netherlands
    Posts
    191
    Hi,

    I think you have to use the older version of exp. But you don't need it on the 9i server, you can just export on the 7.3 server. Using sql*net.

    On the version 7 server:
    exp username/password@db9i
    Ruud Schilders
    -----------------
    Oracle DBA
    e-mail : ruud@schilders.it
    URL : www.schilders.it
    Twitter : www.twitter.com/ruudschilders

  3. #3
    Join Date
    Feb 2002
    Location
    San Francisco, CA
    Posts
    441
    so how does this work?

    I need to create the files in the exp73 format, using sql*net would not do this would it?

  4. #4
    Join Date
    Apr 2001
    Location
    Netherlands
    Posts
    191
    Oops... I see that export 9i -> import 7.3 is not supported... you might have to have 8.0 in between.

    (9i->80->73)

    See this metalink doc:
    http://metalink.oracle.com/metalink/...&p_id=132904.1
    Compatibility Matrix for Export & Import Between Different Oracle Versions
    Ruud Schilders
    -----------------
    Oracle DBA
    e-mail : ruud@schilders.it
    URL : www.schilders.it
    Twitter : www.twitter.com/ruudschilders

  5. #5
    Join Date
    Feb 2002
    Location
    San Francisco, CA
    Posts
    441
    so what do you suggest - what is the command syntax for making a dump file from exp80 compatible with imp73?

    I could use exp73 - apart from it is the Alpha version.

  6. #6
    Join Date
    Jun 2002
    Location
    Indianapolis
    Posts
    21
    http://oradoc.photo.net/ora817/DOC/s.../ch01.htm#4663

    Use the lowest version of the tools.

  7. #7
    Join Date
    Feb 2002
    Location
    San Francisco, CA
    Posts
    441
    ok - where can i get a windows/intel copy of the exp73 tool? as I only have a copy of exp73 for windows/alpha - is this going to be freely availble or will i have to pay?

Posting Permissions

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