Results 1 to 5 of 5
  1. #1
    Join Date
    Jun 2009
    Posts
    17

    Unanswered: Importing oracle 10g dump to oracle 9i

    Hi,

    i have oracle 10g export dump file, when am trying to import that in oracle 9i
    its giving error like unknown dumpfile format.


    pl help me, what can we do with this error.

    Thanks ,
    Lucky.

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Gee, exactly the same (OK, not exactly, but very close) question has been asked here, and it was placed at the top of this Forum at the time you've posted your question. Searching the board (or at least keeping your eyes open) helps.

  3. #3
    Join Date
    Jun 2009
    Posts
    2
    You cannot import a 10g dump file into 9i database.

    Work around is;

    Export from 10g using 9i export utility
    Use the dump file to import into 9i database

    Hope this helps!!

    Cheers

  4. #4
    Join Date
    Jun 2009
    Posts
    17
    hello,

    ya it was helpful.

    will it be same for all higher version to lower version.

    Thanks in advance.

  5. #5
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    Its been that way since Oracle 5.
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

Posting Permissions

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