What is the "SYS EXPORT SCHEMA 01" table in the NuGenesis schemas, and can it be dropped? - WKB220492

ENVIRONMENT

• NuGenesis 9 SDMS
  • Oracle 12c/19c
• NuGenesis 8 SDMS
  • Oracle 11g

ANSWER

The "SYS_EXPORT_SCHEMA_01" table is created during a DataPump export process, and it is normally deleted at the end of that process. If the table remains in the schema after the export, it means that the export process did not complete successfully. The NuGenesis schemas do not rely on these tables and they can be dropped.

ADDITIONAL INFORMATION