Database Utilities (MOSC)

MOSC Banner

Data Pump Import from multiple directories

edited Feb 21, 2012 3:40AM in Database Utilities (MOSC) 4 commentsAnswered
Hi folks,
Trying to import some dumps using impdp, due to space issues, have to store dmp files at 3 different directoires and now when trying to import, giving errors, any help/assistance or guidance will highly be appreciated, thanks.

11gR2 - 2 node RAC on Solaris

this is my parfile:

dumpfile=DP_DIR1:mobi_np_refresh_%u.dmp,DP_DIR2:mobi_np_refresh_%u.dmp,DP_DIR3:mobi_np_refresh_%u.dmp
logfile=DP_DIR:imp_scm1777_mobi_ddl.log
sqlfile=DP_DIR:imp_scm1777_mobi_ddl.sql
tables=scott.V_CATEGORY,scott.V_ONLINE_CATEGORY
parallel=8
metrics=yes
trace=480300

and now the error, but the directory exists on this db:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center