Import data into Oracle 9i from Oracle 8i database

[shailaja]

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

[davey23uk]

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

[Thomasps]

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.

[bhattnirav]

- 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

[RayaguruSD]

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.

[reydp]

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

[davey23uk]

dont need to do any of that, just move the database from one server to another and upgrade it - quicker