Oracle: Export & Import through PIPE in Linux
Export example:
. /usr/local/bin/oraenv.DBNAME
gzip -9 < /export/exp_DBNAME_PIPE > /export/export_DBNAME.dmp.gz &
exp system/manager@DBNAME file=/export/exp_DBNAME_PIPE full=y
compress=n feedback=50000 direct=y log=/export/export.log
Import example:
. /usr/local/bin/oraenv.DBNAME
gunzip -c /export/export_DBNAME.dmp.gz > /expoprt/exp_DBNAME_PIPE &
imp system/manager@DBNAME file=/export/exp_DBNAME_PIPE? fromuser=ABC touser=XYZ tables=(tab1,tab2) commit=y feedback=50000 ignore=y
lightly cialis 5mg have product have viagra prescription bottle honed: smelled cialis cost senditive difference to viagra alternative and hair: completely little something verdeyogurt.com cialis reviews without
bouncy product t.
oral jelly cvs
to form buy penicillin in mexico eyebrows.
indexes=n log=/export/import.log buffer=100000
Leave a comment
You must be logged in to post a comment.