We have our current production database in Oracle 188.8.131.52 on Solaris 8, and we are planning on moving to 10gR2. This upgrade will be totally on a new Solaris 10 server. The question I have is, once I have the new box ready with 10gR2, what is the best way to move my data from the 184.108.40.206 DB? I usually do an exp/imp. Is that the best method? I have about 30GB of data with around 40 tablespaces and not many schemas (six schemas). Does 10gR2 offer a better method of migrating data from Oracle 220.127.116.11? Any help is greatly appreciated.
You are not only upgrading your database, but you are migrating it to another server. Since the database is not large (only 30 GB), I would recommend using Oracle's export and import utilities to accomplish this. The
Oracle Database 10g Release 2 (10.2) Upgrade Guide
describes the various options available to you to upgrade an Oracle database to 10gR2. Basically, you can upgrade your database in place via the Database Upgrade Assistant (DBUA) or manually through scripts. Another option is to copy your database across from one database to another using a database link, but this is prone to error and requires more effort than using export/import. Finally, you can use the export and import utilities which are what I would recommend in this case.
Dig Deeper on Oracle database backup and recovery
Can I use /var/opt/oracle/oratab to specify listener information?
We would like to migrate our database from Oracle 8.1.7 to Oracle 10g. We would like to know the impact for our application developed using Delphi ...
I have been trying to install Oracle 8.1.7 on SUSE Linux 9.0 and got the error:
"Error in invoking target install of makefile /opt/oracle/...../*.mk."