We are planning to upgrade Oracle from 8.0.6 to 9i. Since we have a new server, could I do following:
- Install Oracle 9i on new server
- Export full database from 8.0.6
- Create mew instance on new server
- Import full dump file to new instance
I am not sure how this method will affect SYS and SYSTEM objects? Please advice.Do I have easy way to upgrade in our environment?
You can upgrade directly by following the instructions in the 9i documentation book titled, Migration.
You can also use export/import to move to the new instance if you wish. This may provide advantages like the ability to easily employ new features like locally-managed tablespaces, automatic undo management, and others. You should not have any objects created under the SYS or SYSTEM schemas, and Oracle will take care of migrating its own objects, so you don't need to worry about those accounts.
The choice is yours. If the data set is small enough, I'd probably create a new database with locally-managed tablespaces and use export/import to migrate. If it is large, then I'd upgrade it and use "alter table ... move" statements to move the tables into newly-created locally-managed tablespaces after upgrade.