purging AQ tables
We are following How To Purge Fnd_AQ Tables (Doc ID 1156523.1) for purging AQ tables and we are getting bellow error
SQL> DECLARE
po dbms_aqadm.aq$_purge_options_t;
BEGIN
po.block := FALSE;
DBMS_AQADM.PURGE_QUEUE_TABLE(
queue_table => 'AQ$_FND_CP_GSM_OPP_AQTBL_T',
purge_condition => NULL,
purge_options => po);
END;
/ 2 3 4 5 6 7 8 9 10
DECLARE
*
ERROR at line 1:
ORA-24019: identifier for QUEUE_TABLE too long, should not be greater than 24
characters
ORA-06512: at "SYS.DBMS_AQADM", line 1471
ORA-06512: at line 5
SQL>
Kindly help us in resolving this issue.
Regards,
Surya Prakash