Purposes of Import and Export utilities

Export and Import are the utilities provided by oracle in order to write data in a binary format from the db to OS files and to read them back.

These utilities are used:

• To take backup/dump of data in OS files.
• Restore the data from the binary files back to the database.
• move data from one owner to another

Oracle - What are the purposes of Import and Export utilities? - June 27, 2009 at 11:00 AM

What are the purposes of Import and Export utilities?  

Import and Export utilities are helpful in following ways:

They can be used for backup and recovery process.
They can also be used while moving database between two different oracle instances.
These utilities can be used to move data from one tablespace to other.

Also read

What is the difference between the SQL*Loader and IMPORT utilities?

SQL*Loader can be used to load data from Delimiter separated files and fixed............

Oracle Import export

What are the use of Export and Import command?, What are the parameters to be provided while executing Export and Import commands?, What is the difference between the SQL*Loader and IMPORT utilities?..............

What are data pump Export and Import Modes?

Data pump export and import modes are used to determine the type and portions of database to be exported and imported:................

<<Previous  Next>>

Write your comment - Share Knowledge and Experience