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
Monday, July 03, 2006
Subscribe to:
Post Comments (Atom)
1 comment:
Thank you for help
Post a Comment