Home » RDBMS Server » Server Utilities » Exclude badly formatted (RDBMS 11.2.0.2 RHEL6)
Exclude badly formatted [message #521705] Thu, 01 September 2011 06:50 Go to next message
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 #521709 is a reply to message #521705] Thu, 01 September 2011 08:04 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Did you solve your issue on http://www.orafaq.com/forum/m/521688/102589/#msg_521688?
If yes, please feedback.

Regards
Michel
Re: Exclude badly formatted [message #522102 is a reply to message #521709] Tue, 06 September 2011 08:31 Go to previous messageGo to next message
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

Re: Exclude badly formatted [message #522105 is a reply to message #522102] Tue, 06 September 2011 08:49 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Could you then put this solution in the appropriate topic.

Regards
Michel
Previous Topic: Problems Loading Data Into Table - SQL Loader
Next Topic: Removed the current archive logs
Goto Forum:
  


Current Time: Thu Mar 28 13:09:18 CDT 2024