Export 9.2 import 8i question
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Export 9.2 import 8i question

  1. #1
    Join Date
    Nov 2002
    Location
    Argentina
    Posts
    24

    Question Export 9.2 import 8i question

    Hello:
    I need to export an schema from an Oracle 9.2.0.1 and import it into an empty Oracle 8i database.
    I tried the export and import but it doesnt work.. could somebody help me with this , please .
    Marcelo Quesada
    :)

  2. #2
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    You will need to use the export utility from the lowest version of the RDBMS.

    In your case you will need to use the 8i one.

    Regards
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

  3. #3
    Join Date
    Sep 2001
    Location
    Düsseldorf, Germany.
    Posts
    588
    Originally posted by jovery

    You will need to use the export utility from the lowest version of the RDBMS.

    In your case you will need to use the 8i one.
    +

    Before using EXP utility of Oracle8i to export Oracle 9i database, you may have to execute catexp8.sql (must be in
    oracle9i_home/rdbms/admin/) on Oracle 9i database. This sql script creates lower version views required for oracle8i exp utility.

    Then as Jim said, use Oracle 8i exp utility to export Oracle9i databaase and import using 8i IMP utility...

    HTH

    Sameer

  4. #4
    Join Date
    Nov 2002
    Location
    Argentina
    Posts
    24
    Thanks!
    Marcelo Quesada
    :)

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