CRITICAL SKILL 5.8
Use Traditional Export and Import
The original (non–Data Pump) Export and Import utilities that were used in pre–Oracle10g versions can be found in Oracle Database 10g. However, we strongly recommend you use the new Data Pump utilities since they support all Oracle Database 10g features and will increase performance. Here, we’ll review the original Export and Import utilities since you’ll be using them with earlier versions of Oracle.
How to Run the Original Utilities
Before running the original export and import, the catexp.sql catalog script needs to be run to prepare Oracle for these utilities, and it is invoked from the catalog.sql script. These scripts can be found in the ORACLE_HOME/rdbms/admin directory.
Once the catalog ...
Get Oracle Database 10g: A Beginner's Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
