Database Utilities (MOSC)

MOSC Banner

Error in parameter file using IMPDP

edited Sep 1, 2011 3:16AM in Database Utilities (MOSC) 6 commentsAnswered
Hi!
I get this error:'

With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-39001: invalid argument value
ORA-39071: Value for EXCLUDE is badly formed.
ORA-00920: invalid relational operator

My parfile:

directory=dump
dumpfile=rmsprod%U.dmp
logfile=imp.log
Exclude=SCHEMA:\"IN \(\'AWTEST\',\'AWPROD\',\'DBSNMP\',\'ORCACLE_OCM\',\'MGMT_VIEW\',\'OUTLN\',\'PAFO\',\'PERFSTAT\',\'RMAN\',\'SYS\',\'SYSTEM\',\'SYSMAN\',\'TSMSYS\',\'WMSYS\'\)\"
Exclude=STATISTICS
Exclude=INDEX

What is wrong?

Regards
U

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