Home » RDBMS Server » Server Utilities » datapump Exclude Parameter (11gr2 LINUX)
datapump Exclude Parameter [message #559738] Thu, 05 July 2012 16:00 Go to next message
chandu208
Messages: 17
Registered: July 2012
Junior Member
how to take all schema metadata export except one schema(scott)
can i use like EXCLUDE=schema:\"IN('SCOTT')
Re: datapump Exclude Parameter [message #559740 is a reply to message #559738] Thu, 05 July 2012 16:08 Go to previous messageGo to next message
Littlefoot
Messages: 21598
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
What happened when you tried it?

(By the way, yes - you can exclude a schema, as described in documentation).
Re: datapump Exclude Parameter [message #559743 is a reply to message #559740] Thu, 05 July 2012 17:16 Go to previous messageGo to next message
chandu208
Messages: 17
Registered: July 2012
Junior Member
thanks, but i dont need even the objects of that excluded schema. what to do for this? any answers?
Re: datapump Exclude Parameter [message #559744 is a reply to message #559743] Thu, 05 July 2012 17:19 Go to previous messageGo to next message
BlackSwan
Messages: 26733
Registered: January 2009
Location: SoCal
Senior Member
Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/
Re: datapump Exclude Parameter [message #559768 is a reply to message #559744] Fri, 06 July 2012 00:54 Go to previous message
Littlefoot
Messages: 21598
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Really, why would you bother reading the documentation? Not to mention searching for it by yourself; but no, even if you are provided with a direct link, you refuse to have a look. OK then, here you are (open your mouth):
Quote:

To exclude a specific user and all objects of that user, specify a filter such as the following (where hr is the schema name of the user you want to exclude):
EXCLUDE=SCHEMA:"='HR'"

/forum/fa/3943/0/
Previous Topic: ORA-22303
Next Topic: Error During IMPDP
Goto Forum:
  


Current Time: Tue Sep 29 16:44:13 CDT 2020