Database Utilities (MOSC)

MOSC Banner

Data Pump Export - Filtering schemas

Hello

In our 19.24 database we are trying to export ONLY the schemas and users that are application specific and there is a long list of that

So basically we are trying to perform schema level export for those schemas

here is how our par file looks like

exclude=statistics
exclude=schema:"IN (SELECT username FROM dba_users where oracle_maintained='Y')"
full=y
parallel=12
LOGTIME=ALL
METRICS=YES

But it seems it is not filtering the schemas out and instead exporting even the oracle maintained schemas..

21-MAY-25 00:42:38.946: W-12 . . exported "WMSYS"."WM$WORKSPACES_TABLE$" 12.10 KB 1 rows in 0 seconds using direct_path

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