- You can go from one OS platform to another; for instance the old db server could be Sun Solaris and the new one can be Linux.
- You can upgrade at the same time. Create a dump file with your Oracle 8.0.5 software. Then use Oracle 10g's imp utility to import into your new 10g database on the new db server. The database will be upgraded in this step.
- You can perform any database reorganizations you need to do at the same time.
- You can change the DB_BLOCK_SIZE if needed at this time.
The downside to using exp and imp is that a larger database can take a long time to import. However, 20GB is not that large of a database so I would probably use exp and imp for my database move to the new server. Use these steps:
- On the new db server, install the Oracle software and precreate any tablespaces you'll need.
- Optionally, precreate any users you'll need in the new database.
- On the old database server, take a full export of your database:
exp userid=system/manager file=full.dmp log=exp.log full=yI always log my session's output for reference.
- FTP the dump file to the new database server in binary mode.
- Import the dump file's contents on the new database server:
imp userid=system/manager file=full.dpm log=imp.log full=y
That should complete your move!
This was first published in October 2005