partition error

Posted by Roshan on Oct 13, 2016; 9:29am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/partition-error-tp1392.html

Hello Erman,

one user is having the following error:
The script to manage the partition in Billing failed again with the below message

oracle_linux>more BILLING_PARTITION_MANAGE_20161013052001.log
13/10/2016 05:20:01 -> Process start ...
13/10/2016 05:20:01 -> HD_ARCHIVE_PURGE.MANAGE_NEW_PARTITION in progress

PL/SQL procedure successfully completed.

13/10/2016 05:20:01 <- HD_ARCHIVE_PURGE.MANAGE_NEW_PARTITION terminated
13/10/2016 05:20:01 -> HD_ARCHIVE_PURGE.MANAGE_PURGE in progress
BEGIN HD_ARCHIVE_PURGE.MANAGE_PURGE(); END;

*
ERROR at line 1:
ORA-01555: snapshot too old: rollback segment number 0 with name "SYSTEM" too
small
ORA-06512: at "HDBUSR.HD_ARCHIVE_PURGE", line 905
ORA-06512: at line 1


13/10/2016 05:20:01 <- HD_ARCHIVE_PURGE.MANAGE_PURGE terminated
Archivage des fichiers /data/ora/PMTBIL01/u02/HD_283112519034_20160714_1.dat/dmp/log
13/10/2016 05:54:26 <- Process terminated
oracle_linux>

I checked the Master note (Doc ID 1307334.1)

It is a bit complex.

Thanks,
Joe