Skip to main content
edited tags
Link
Philᵀᴹ
  • 31.9k
  • 10
  • 84
  • 108
deleted 10 characters in body
Source Link
Marco
  • 3.7k
  • 5
  • 24
  • 31

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

my question is really simple, and does not need any particular documentation. When I run expdp 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

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

No error message with expdp, just missing tables..... Could anyone please give me suggestions about this? Thanks a lot,

Nick

my question is really simple, and does not need any particular documentation. When I run expdp 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

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

No error message with expdp, just missing tables..... Could anyone please give me suggestions about this?

Source Link
Nick
  • 3
  • 2

incomplete sysaux expdp unload (ORACLE)

my question is really simple, and does not need any particular documentation. When I run expdp 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

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

No error message with expdp, just missing tables..... Could anyone please give me suggestions about this? Thanks a lot,

Nick