my question is really simple, and does not need any particular documentation.
When I run expdpexpdp
command like this using Oracle Database 11g Release 11.2.0.4.0 - 64bit:
expdp system/******* directory=DATA_PUMP_DIR dumpfile=SYSAUX.dmp logfile=sysaux.log TABLESPACES=SYSAUX
expdp system/******* directory=DATA_PUMP_DIR dumpfile=SYSAUX.dmp logfile=sysaux.log TABLESPACES=SYSAUX
I see that no table about SYSTEM schema is present. I know for sure that tables in SYSTEM schema belong to SYSAUX tablespace, like DBA_SEGMENTS and DBA_EXTENTS tell me, but I don't see any log row like this: . . exported "SYSTEM"."TABLENAME" 120.2 GB 8396874 rows
.. exported "SYSTEM"."TABLENAME" 120.2 GB 8396874 rows
No error message with expdpexpdp
, just missing tables.....
Could anyone please give me suggestions about this?
Thanks a lot,
Nick