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.