Database Administration (MOSC)

MOSC Banner

ORA-20011

edited Jun 9, 2014 10:55AM in Database Administration (MOSC) 2 commentsAnswered

We are getting ORA-20011 at 10 PM when the dbms_stats starts every weekday. I followed doc id 1274653.1  to lock table stats, and in another database I'm following doc id 336014.1. I ran this query

  1* select * from dba_datapump_jobs

OWNER_NAME                     JOB_NAME
------------------------------ ------------------------------
OPERATION
--------------------------------------------------------------------------------
JOB_MODE
--------------------------------------------------------------------------------
STATE                              DEGREE ATTACHED_SESSIONS DATAPUMP_SESSIONS
------------------------------ ---------- ----------------- -----------------
SYS                            SYS_IMPORT_FULL_01
IMPORT
FULL
NOT RUNNING                             0                 0                 0

SYS                            SYS_EXPORT_SCHEMA_01
EXPORT
SCHEMA
NOT RUNNING                             0                 0                 0


2 rows selected.

I want to know if its safe to drop the SYS.SYS_IMPORT_FULL_01 and SYS.SYS_EXPORT_SCHEMA_01 ?

Thanks

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center