- 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!
Dig Deeper on Oracle database backup and recovery
Related Q&A from Brian Peasland
Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs. Continue Reading
One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command. Continue Reading
Managing parent table-child table relations in Oracle SQL environments is key to efficient programming. Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.