O'Reilly logo

Oracle Database 10g: A Beginner's Guide by Michael Corey, Michael Abbey, Ian Abramson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required