Database Utilities (MOSC)

MOSC Banner

11.2.0.4 Expdp - selective schemas export using a query?

edited Apr 12, 2019 5:05AM in Database Utilities (MOSC) 11 commentsAnswered

Hi

We have a 11.2.0.4 database with hundreds of users

We want to perform a schema level export EXCLUDING only a few schemas / users

We can use SCHEMA='USER A', 'USER B'       

but that will be tedious so we are wondering if there is a way we can pass on the usernames we would like to export using a query?

Like 'Select username from dba_users where user_name not in ("few users we dont want to be exported") and pass that user list to expdp to export?

Thanks in advance for your guidance

Kind Regards

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