EXPORT & IMPORT (DATAPUMP)

Export and import will be taken in schema level and table level

To export and import in user is called schema level

To export and import files or tables is called table level

Export and import can be done in schemas, tables and full data base

Schema level:

To export and import in user is called schema level

(Root level query)

Expdp directory = directory name, schema = schema name, dump file = dmp log file =. Log compression = all parallel = cpu count/2

Expdp directpry = directory name, schema = schema name, dumpfile = log.compression = all parallel = cpu count/2

Impdp directory = directory name, schema = schema name, dump file = dmp.logfile = .log compression = all parallel = cpu count/2

Table level :

To export and import in tables is called table level

In table level export we will take only table backup

ie. Export of particular table with the help of table export we can store the data on the export dumps. If anything like data misise, we need to import the same table in database.

Expdp directory = directory name, tables = username.tablename, username.tablename2 dumpfile = dmp log file = .log compression = all parallel = cpu count/2

Create a directory 

MK dir expdp_table_ddmmyyyy

Sql> create directory expdp_table_ddmmyyyy as path/path/path

Expdp directory = expdp_ table_ddmmyy tables = user name =.table1, username.table2 dumpfile = exp_table_ddmmyy.dmp log file = expdp_ table_ddmmyy.log compression= all parallel= cpu count/2

Remap_table

Remap_schema

Y=full

Impdp directory = directory name, schema = schema name dump file name. dmp logfile = log compression = all parallel = cpu count/2