SYS_EXPORT_SCHEMA_01、SYS_EXPORT_SCHEMA_02表是什么
oralce 用户下发现 SYS_EXPORT_SCHEMA_01、SYS_EXPORT_SCHEMA_02 表，这些表是 expdp 的时候生成，一般导入导出任务完成后会自动删除这些表，可以手动删除这些表。
通过查询任务状态，当任务是 NOT RUNNING 就可以删除，这些任务可能是意外终止导致。
|
1 2 3 4 5 |
SELECT owner_name, job_name, rtrim(operation) "OPERATION", rtrim(job_mode) "JOB_MODE", state, attached_sessions FROM dba_datapump_jobs WHERE job_name NOT LIKE 'BIN$%' ORDER BY 1, 2; |
|
1 2 3 4 5 6 7 |
SELECT o.status, o.object_id, o.object_type, o.owner || '.' || object_name "OWNER.OBJECT" FROM dba_objects o, dba_datapump_jobs dj WHERE o.owner = dj.owner_name AND o.object_name = dj.job_name AND dj.job_name NOT LIKE 'BIN$%' ORDER BY 4, 2; |
分类: oracle