What are the use of Export and Import command?

What are the use of Export and Import command?

- Import and export in Oracle is used to move logical objects like tables in and out of the database.
- 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.

Example:
Export entire database in db..dmp file:
exp SYSTEM/password FULL=y FILE=dba.dmp LOG=dba.log CONSISTENT=y

FULL specifies the entire database to be dumped.
Parameters to be provided while executing Export and Import commands
The parameters that need to be provided while executing IMPORT or EXPORT commands are:...
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...
Post your comment

Related Content

Follow us

▲