Home » Server Options » Replication » problem in executing SCHEDULE_PURGE
problem in executing SCHEDULE_PURGE [message #264329] Mon, 03 September 2007 00:55 Go to next message
tanmoy1048
Messages: 133
Registered: June 2007
Senior Member
BEGIN
DBMS_DEFER_SYS.SCHEDULE_PURGE (
next_date => SYSDATE,
interval => 'SYSDATE + 1/24',
delay_seconds => 0);
END;
/

And, I got the error
ERROR at line 1:
ORA-00600: internal error code, arguments: [kglrfst: cursor on dependents li],
[0x384777160], [], [], [], [], [], []
ORA-06508: PL/SQL: could not find program unit being called:
"SYS.DBMS_INTERNAL_LOGSTDBY"
ORA-06512: at "SYS.DBMS_DEFER_SYS", line 3038
ORA-01403: no data found
ORA-06512: at line 2

thanx.
Re: problem in executing SCHEDULE_PURGE [message #264333 is a reply to message #264329] Mon, 03 September 2007 01:04 Go to previous messageGo to next message
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
ORA-00600 = Oracle bug => search on Metalink and/or call Oracle support

Regards
Michel
Re: problem in executing SCHEDULE_PURGE [message #264337 is a reply to message #264329] Mon, 03 September 2007 01:10 Go to previous messageGo to next message
tanmoy1048
Messages: 133
Registered: June 2007
Senior Member
THANX BUDDY,
but..I executed this on two db. one of them had no problem and another 1 gave that error.

So, any other suggestion ...
Re: problem in executing SCHEDULE_PURGE [message #264349 is a reply to message #264337] Mon, 03 September 2007 01:37 Go to previous messageGo to next message
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
A bug is a bug, sometimes it raises sometimes no, it depends iof the required conditions are met. So no other suggestion.
Did you try these ones yet?

Regards
Michel
Re: problem in executing SCHEDULE_PURGE [message #264354 is a reply to message #264329] Mon, 03 September 2007 01:44 Go to previous message
tanmoy1048
Messages: 133
Registered: June 2007
Senior Member
so..is there any alternative way?? or I shud leave it.
Previous Topic: Problem with replication across version
Next Topic: snapshot document
Goto Forum:
  


Current Time: Sun Dec 22 22:11:59 CST 2024