| Exclude badly formatted [message #521705] |
Thu, 01 September 2011 06:50  |
hristo
Messages: 258
Registered: May 2007
|
Senior Member |
|
|
Hi!
Im trying to use IMPDP, this is my EXCLUDE:
Exclude=INDEX,STATISTICS,SCHEMA:\"IN \(\'AWTEST\',\'AWPROD\',\'DBSNMP\',\'ORCACLE_OCM\',\'MGMT_VIEW\',
\'OUTLN\',\'PAFO\',\'PERFSTAT\',\'RMAN\',\'SYS\',\'SYSTEM\',\'SYSMAN\',\'TSMSYS\',\'WMSYS\'\)\
But I get this:
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
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
How do I write a correct EXCLUDE?
Regards
H
[Updated on: Thu, 01 September 2011 08:05] by Moderator Report message to a moderator |
|
|
|
|
|
| Re: Exclude badly formatted [message #522102 is a reply to message #521709] |
Tue, 06 September 2011 08:31  |
hristo
Messages: 258
Registered: May 2007
|
Senior Member |
|
|
I solved this one by putting the code in a parameter file (you dont have to escape ' like you have to when running it on the OS).
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, INDEX
[Updated on: Tue, 06 September 2011 08:45] Report message to a moderator |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
