Parameters to be provided while executing Export and Import commands

What are the parameters to be provided while executing Export and Import commands?

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;
Difference between the SQL*Loader and IMPORT utilities
SQL*Loader is a bulk loader utility used for moving data from external files into the Oracle database.....
Difference between locks, latches, enqueues and semaphores
Difference between locks, latches, enqueues and semaphores - Latches are used to protect Oracles data structures to be modified or run by more than one process...
Oracle system privilege
Oracle system privilege - user privileges, developer privileges, “any” privileges, database maintenance, monitoring privileges.....
Post your comment

Related Content

Follow us

▲