|
Oracle Import and Export - August 11, 2008 at 15:00 PM by Amit Satpute
What are the use of Export and Import command?
Answer
Use the IMPORT command to import data into a nickname from a file and
the EXPORT command to export data from a nickname to a file.
What are the parameters to be provided while executing Export and Import
commands?
Answer
The parameters that need to be provided while executing IMPORT or EXPORT
commands are:
The file name
Write access
The commit count number
The nickname
For example:
IMPORT FROM file_1.ixf OF IXF
ALLOW WRITE ACCESS
COMMITCOUNT 20
INSERT INTO NICKNAME_1;
What is the difference between the SQL*Loader and IMPORT
utilities?
Answer
SQL*Loader is a bulk loader utility used for moving data from external files
into the Oracle database. SQL*Loader supports various load formats, selective
loading, and multi-table loads.
Oracle's export (exp) and import (imp) utilities are used to perform logical
database backup and recovery. When exporting, database objects are dumped to a
binary file which can then be imported into another Oracle database.
|