Monday, July 03, 2006

Oracle DATA PUMP include exclude tables

Export table by exclude and include tables
example:
#expdp DIRECTORY=tmp dumpfile=test2.dmp logfile=log include=TABLE:\"IN \(\'ADDRESS_BOOKS\', \'ADDR\'\)\" schemas=surachart

expdp DIRECTORY=tmp dumpfile=test2.dmp logfile=log exclude=TABLE:\"IN \(\'ADDRESS_BOOKS\', \'ADDR\'\)\" schemas=surachart


Import table by exclude and include tables
example:
#impdp DIRECTORY=tmp dumpfile=test2.dmp logfile=log2 REMAP_SCHEMA=surachart:chart INCLUDE=TABLE:\"= \'ADDRESS_BOOKS\'\"

#impdp DIRECTORY=tmp dumpfile=tetst2.dmp logfile=log2 REMAP_SCHEMA=surachart:chart EXCLUDE=TABLE:\"= \'ADDRESS_BOOKS\'\"


otherwise case
remap_tablespace
# impdp DIRECTORY=tmp dumpfile=tet,dmp logfile=log2 REMAP_tablespace=one:DEVELOPERS

1 comment:

Kelloggsville said...

Thank you for help