The best place to *find* answers to programming/development questions, imo, however it's the *worst* place to *ask* questions (if your first question/comment doesn't get any up-rating/response, then u can't ask anymore questions--ridiculously unrealistic), but again, a great reference for *finding* answers.

My Music (Nickleus)

20120220

how to exclude multiple files when importing with impdp for oracle xe

su oracle
cd /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin
nano -w params.txt

give it the following content, e.g.:

DIRECTORY=data_pump_dir
DUMPFILE=my_expdat.dmp
EXCLUDE=TABLE:"IN ('TABLE1,TABLE2')"
TABLE_EXISTS_ACTION=REPLACE

save it, then run impdp like this:
./impdp system@MYDATABASE PARFILE=params.txt


source: http://www.orafaq.com/forum/t/174436/0/
Posted by Nickleus at 17:55:00

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)