Any guidelines for migrating Oracle Advanced queues via exp(dp)/imp(dp)?
I'm a noob regarding Oracle advanced queuing so any help would be appreciated.
I'm migrating from a 10G database to an 11G database via expdp/impdp. When I did a full schema expdp/impdp all the queue tables were migrated. However when I attempt to do a table level transfer I'm having some confusing results.
When I create the queue using the create_queue procedure:
BEGIN
SYS.DBMS_AQADM.CREATE_QUEUE_TABLE
(
QUEUE_TABLE => 'TEST.QUE_DVC_GPRS'
,QUEUE_PAYLOAD_TYPE => 'TEST.TYP_DEVICE_NOTIFICATION'
,COMPATIBLE => '8.1'
,STORAGE_CLAUSE => 'NOCOMPRESS
TABLESPACE QUE_DVC_DATA
PCTUSED 0
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
0