We run the Oracle payroll application on a 8.1.7 database. We are upgrading the application to enable a patch install and will also upgrade the database to 9i. The database runs off AIX 4.3.3 but will move to 5L. The work is being done by Oracle and involves two trials: trial 1 is a system test and trial 2 is UAT.
My question regards the database upgrade. As the database data is sensitive we will not share this with Oracle, hence should our DBA do a full copy or an export? When you do a full copy or export are things like schema objects copied across and the tablespace allocated to these schemas? Is there a Web resource which lists all the elements that are copied across under a full copy and an export?
One final point -- data currently resides on a storage area network but will move to network attached storage.
When you perform a full export of the database, all objects in the database will be in the created dump file. This includes tables, indexes, procedures, triggers, sequences, etc. The best resource for understanding the export/import utilities is the documentation. Look for the Utilities Guide for your version for information on export and import.
This was first published in December 2006