Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Datapump error

User_7R7B7Dec 21 2016 — edited Dec 22 2016

I'm showing this many jobs in my database should i dropped all the tables below?

OWNER_NAME JOB_NAME             OPERATION    JOB_MODE     STATE        ATTACHED_SESSIONS

---------- -------------------- ------------ ------------ ------------ -----------------

MSOW       SYS_EXPORT_SCHEMA_01 EXPORT       SCHEMA       NOT RUNNING                  0

MSOW       SYS_EXPORT_TABLE_01  EXPORT       TABLE        NOT RUNNING                  0

MSOW       SYS_EXPORT_TABLE_03  EXPORT       TABLE        NOT RUNNING                  0

MSOW       SYS_EXPORT_TABLE_04  EXPORT       TABLE        NOT RUNNING                  0

MSOW       SYS_EXPORT_TABLE_05  EXPORT       TABLE        NOT RUNNING                  0

SYSTEM     SYS_EXPORT_SCHEMA_01 EXPORT       SCHEMA       NOT RUNNING                  0

SYSTEM     SYS_EXPORT_SCHEMA_03 EXPORT       SCHEMA       NOT RUNNING                  0

SYSTEM     SYS_EXPORT_SCHEMA_04 EXPORT       SCHEMA       NOT RUNNING                  0

SYSTEM     SYS_EXPORT_SCHEMA_05 EXPORT       SCHEMA       NOT RUNNING                  0

SYSTEM     SYS_EXPORT_SCHEMA_06 EXPORT       SCHEMA       NOT RUNNING                  0

SYSTEM     SYS_EXPORT_SCHEMA_07 EXPORT       SCHEMA       NOT RUNNING                  0

11 rows selected.

SQL> SELECT o.status, o.object_id, o.object_type,

       o.owner||'.'||object_name "OWNER.OBJECT"

  FROM dba_objects o, dba_datapump_jobs j

WHERE o.owner=j.owner_name AND o.object_name=j.job_name

   AND j.job_name NOT LIKE 'BIN$%' ORDER BY 4,2;   2    3    4    5

STATUS   OBJECT_ID OBJECT_TYPE         OWNER.OBJECT

------- ---------- ------------------- --------------------------------------------------

VALID       143793 TABLE               MSOW.SYS_EXPORT_SCHEMA_01

VALID        41379 TABLE               MSOW.SYS_EXPORT_TABLE_01

VALID        89217 TABLE               MSOW.SYS_EXPORT_TABLE_03

VALID       121067 TABLE               MSOW.SYS_EXPORT_TABLE_04

VALID       135082 TABLE               MSOW.SYS_EXPORT_TABLE_05

VALID        70890 TABLE               SYSTEM.SYS_EXPORT_SCHEMA_01

VALID       136904 TABLE               SYSTEM.SYS_EXPORT_SCHEMA_03

VALID       143006 TABLE               SYSTEM.SYS_EXPORT_SCHEMA_04

VALID       143303 TABLE               SYSTEM.SYS_EXPORT_SCHEMA_05

VALID       143488 TABLE               SYSTEM.SYS_EXPORT_SCHEMA_06

VALID       143659 TABLE               SYSTEM.SYS_EXPORT_SCHEMA_07

This post has been answered by Gbenga Ajakaye on Dec 21 2016
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 18 2017
Added on Dec 21 2016
4 comments
1,133 views