.prm files will be used to dump the table data into a .dmp file.
We can call it from shell scripts and we can pass parameters to .prm file from Shell Script.
tables=(AP.AP_BATCHES_ALL)
query="where org_id=22"
rows=y
indexes=n
grants=n
constraints=n
statistics=none
triggers=n
direct=n
compress=n
log=$APPLCSF/$APPLLOG/exp_ap_batches_all.log
We can call it from shell scripts and we can pass parameters to .prm file from Shell Script.
Syntax:
file=$XXHBCDATA_TOP/outbound/xxhbc_spi_ap_batches_all.dmptables=(AP.AP_BATCHES_ALL)
query="where org_id=22"
rows=y
indexes=n
grants=n
constraints=n
statistics=none
triggers=n
direct=n
compress=n
log=$APPLCSF/$APPLLOG/exp_ap_batches_all.log
No comments:
Post a Comment