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