DATAPUMPING with TABLE level

DATAPUMPING with TABLE level:

ON  STAGING SREVER:

Now command  to execute datapumping

Through system user we have to export tables

But before that give privileges as EXP_FULL_DATABASE role to system user for export

Command: SQL>grant EXP_FULL_DATABASE to system;

Then exit from database go to system level run below command,

$expdp system/manager@GMKP11 directory=DATA_PUMP_DIR tables=dev_ocs.collections,dev_ocs.colmeta dumpfile=colmeta_collections.dmp logfile=colmeta_collections.log table_exists_action=replace

we can give table_exists_action=replace,append,truncate,skip.

Serach that DATA_PUMP_DIR location though SQL command ,

SQL>select directory_name,directory_path from dba_directories;

Trough winscp :Transfer to local system from staging server and then transfer same dump file from local system to stellent.estuate server.

ON  LOCAL SERVER:

Through system user we have to export tables

But before that give privileges as IMP_FULL_DATABASE role to system user for export

Command: SQL>grant IMP_FULL_DATABASE to system;

Then exit from database go to system level run below command,

$impdp system/manager@GMKP11 directory=DATA_PUMP_DIR tables=dev_ocs.collections,dev_ocs.colmeta dumpfile=colmeta_collections.dmp logfile=colmeta_collections_imp.log

Note:check location for DATA_PUMP_DIR location by command:

SQL>select directory_name,directory_path from dba_directories;