What is the Export utility?

What is the Export utility?

Rating:

The Export utility provides a simple way for transferring database objects between Oracle databases even if the database objects reside on platforms with different hardware and software configurations.

When the Export utility is run against an Oracle database, the database objects (such as tables) are extracted, followed by their related objects (such as indexes, comments, and grants), if any. The extracted data is written to an export dump file that is a binary file typically located on disk or tape.

Export dump files can be transferred using FTP or can be physically transported (in the case of tape) to a different location. The export dump files can then be used with the Import utility to transfer data between databases that are on computers not connected through a network. The export dump files can also be used as backups in addition to normal backups.

Export dump files can only be read by the Oracle Import utility. The version of the Import utility should not be earlier than the version of the Export utility used to create the export dump file.

Rating: