|
|
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
|
Locked
