Using Export and Import

Export and Import are two character-mode utilities supplied by Oracle Corporation as early as Oracle4. The utilities perform a function that their name implies: export creates operating-system files of data from Oracle tables and import reads these operating-system files and creates the tables and loads the data back into the tables. The two utilities are used together primarily to back up and restore data, move data to other Oracle databases, and migrate data from earlier releases of Oracle to newer releases.

The common utilities Export and Import also have some serious enhancements. Export and Import now support all objects in a particular tablespace as well as wild-card selections when table objects are selected for ...

Get Oracle9i™ Development by Example 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.