11.2.0.4 Expdp - selective schemas export using a query?
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