we want to export and import tables, functions and sequences, that they have "REWARD%" name.
we created parfile for export and import(when table exist)
parfile for export =>
DIRECTORY=INVENTORY2
dumpfile=REWARD.dmp
logfile=REWARD2.log
include=TABLE:\"like'REWARD%'\"
include=FUNCTION:\"like'REWARD%'\"
include=SEQUENCE:\"like'REWARD%'\"
parfile for import =>
DIRECTORY=INVENTORY2
dumpfile=REWARD.dmp
logfile=REWARD2.log
include=TABLE:\"like'REWARD%'\"
include=FUNCTION:\"like'REWARD%'\"
include=SEQUENCE:\"like'REWARD%'\"
TABLE_EXISTS_ACTION=replace
#expdp parfile=parexport
#impdp parfile=parimport
Friday, July 07, 2006
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment