OraFAQ Forum: Server Utilities » datapump Exclude Parameter

Home » RDBMS Server » Server Utilities » datapump Exclude Parameter (11gr2 LINUX)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

datapump Exclude Parameter [message #559738]

Thu, 05 July 2012 16:00

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')

Report message to a moderator

Re: datapump Exclude Parameter [message #559740 is a reply to message #559738]

Thu, 05 July 2012 16:08

Littlefoot
Messages: 21823
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).

Report message to a moderator

Re: datapump Exclude Parameter [message #559743 is a reply to message #559740]

Thu, 05 July 2012 17:16

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?

Report message to a moderator

Re: datapump Exclude Parameter [message #559744 is a reply to message #559743]

Thu, 05 July 2012 17:19

BlackSwan
Messages: 26766
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/

Report message to a moderator

Re: datapump Exclude Parameter [message #559768 is a reply to message #559744]

Fri, 06 July 2012 00:54

Littlefoot
Messages: 21823
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'"

Report message to a moderator

Previous Topic:	ORA-22303
Next Topic:	Error During IMPDP

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Mar 03 16:09:25 CST 2025