Core Concurrent Processing - EBS (MOSC)

MOSC Banner

purging AQ tables

edited Sep 3, 2015 10:05AM in Core Concurrent Processing - EBS (MOSC) 6 commentsAnswered

We are following How To Purge Fnd_AQ Tables (Doc ID 1156523.1for 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

Tagged:

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