Database Administration (MOSC)

MOSC Banner

how to solve ORA-14012 error reported every day in TRC files on table sys.WRM$_PBP_IN_SNAP?

every day i have a trc file containing entries like this:

*** 2022-08-07T22:28:51.928103+02:00 (SDGDIALT(3))

*** SESSION ID:(96.26798) 2022-08-07T22:28:51.928161+02:00

*** CLIENT ID:() 2022-08-07T22:28:51.928173+02:00

*** SERVICE NAME:(SYS$BACKGROUND) 2022-08-07T22:28:51.928184+02:00

*** MODULE NAME:(MMON_SLAVE) 2022-08-07T22:28:51.928195+02:00

*** ACTION NAME:(AWR Auto-Purge Slave Action) 2022-08-07T22:28:51.928207+02:00

*** CLIENT DRIVER:() 2022-08-07T22:28:51.928217+02:00

*** CONTAINER ID:(3) 2022-08-07T22:28:51.928228+02:00


*** KEUUXS - encountered error: (ORA-14012: Naam van resultaatpartitie conflicteert met naam van een bestaande partitie.

)

 *** SQLSTR: total-len=223, dump-len=223,

   SQLSTR={alter table WRM$_PDB_IN_SNAP split partition WRM$_PDB_IN_SNAP_215357448_MXSN at (215357448,21409) into (partition WRM$_PDB_IN_SNAP_215357448_21409, partition WRM$_PDB_IN_SNAP_215357448_MXSN tablespace SYSAUX) update indexes}

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