Import data into Oracle 9i from Oracle 8i database
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Import data into Oracle 9i from Oracle 8i database

  1. #1
    Join Date
    Jun 2006
    Posts
    1

    Import data into Oracle 9i from Oracle 8i database

    Hi,

    We are in the process of moving from ORacle 8i to ORacle 9i.
    Presently Oracle 8i & Oracle 9i are installed on 2 different server both windows 2000 servers. We have got the database on the Oracle 8i server.
    I have got the export full dump of the oracle 8i database.
    What I need to do now is import this into the Oracle 9i server.
    What is the best way to do this.(Please note that the database is not yet created).
    Also, what changes should we do in the init.ora parameter file which is used for the Oracle 8i database for the Oracle 9i database.

    Thanks & Regards,
    Shailaja

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    you need to create the database first and then just import

    what might be quicker is moving the database to the 9i server, make sure everything is in the same place, startup and upgrade

  3. #3
    Join Date
    Apr 2001
    Location
    Bangalore, India
    Posts
    727
    Quote Originally Posted by shailaja
    Hi,
    Also, what changes should we do in the init.ora parameter file which is used for the Oracle 8i database for the Oracle 9i database.

    Thanks & Regards,
    Shailaja
    This can't be simple question. It should be project and lot of testing.
    Thomas Saviour(royxavier@yahoo.com)
    Technical Lead (Databases)
    Thomson Reuters (Markets)

    http://ora600tom.wordpress.com/

  4. #4
    Join Date
    Apr 2001
    Location
    Vadodara, India
    Posts
    249
    - Take the export of all the schema except sys/system
    - Create logical structure in 9i
    - take import of 8i export file in 9i
    - Gather statistics in 9i

  5. #5
    Join Date
    Jun 2006
    Posts
    6
    there is a bit of problem if u need to downgrade but upgrading using logical export and import works fine.
    else u can use database upgrade assistant too.

  6. #6
    Join Date
    Sep 2001
    Location
    Makati, Philippines
    Posts
    857
    Quote Originally Posted by Thomasps
    This can't be simple question. It should be project and lot of testing.
    Agree...

    1.You need to duplicate tablespaces you use in 8idb to 9idb(doesn't matter if dictionary managed or locally managed).
    2. create user/schema owner in 9idb same with 8idb.(same role/privs)
    3. import your dump file with full=y rows=n
    4. disable constraints and triggers
    5. import your dump file again with full=y rows=y constraint=n ignore=y
    6. enable constraints and triggers
    7. check your object counts in 8idb, compare it in 9idb
    8. check sequence if the same with 8idb.
    9. check imp logs, record counts of tables.

    hi all.... if miss something, glad to be being checked.

    rey
    ---------------

  7. #7
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    dont need to do any of that, just move the database from one server to another and upgrade it - quicker

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