Can I shrink a LOB column for a Advanced Queue table?
Oracle 11.2
I create AQ
BEGIN
SYS.DBMS_AQADM.CREATE_QUEUE_TABLE
(
QUEUE_TABLE => 'MY_Q_TABLE'
,QUEUE_PAYLOAD_TYPE => 'SYS.AQ$_JMS_TEXT_MESSAGE'
,COMPATIBLE => '8.1'
,STORAGE_CLAUSE => 'TABLESPACE DATA'
,SORT_LIST => 'PRIORITY,ENQ_TIME'
,MULTIPLE_CONSUMERS => FALSE
,MESSAGE_GROUPING => 0
,SECURE => FALSE
);
SYS.DBMS_AQADM.CREATE_QUEUE
(
QUEUE_NAME => 'MY_Q_TABLE'
,QUEUE_TABLE => 'MY_Q_TABLE'
,QUEUE_TYPE => SYS.DBMS_AQADM.NORMAL_QUEUE
,MAX_RETRIES => 0
,RETRY_DELAY => 0
,RETENTION_TIME => 1209600
);
SYS.DBMS_AQADM.START_QUEUE
(
QUEUE_NAME => 'MY_Q_TABLE'
,ENQUEUE => TRUE
,DEQUEUE => TRUE
);
End;
When I read https://docs.oracle.com/database/121/ADQUE/aq_admin.htm#ADQUE0800
Note: