Datapump out application users oracle account

A useful trick for exporting out a set list of oracle accounts - we used this to extract all of our application users - the query can be anything you choose.

include=SCHEMA:"IN (select username from dba_users where user_id > 30 and username not like APP_SCHEMA_OWNER%')"
include=ROLE
full=y

Comments