Database Utilities (MOSC)

MOSC Banner

Any guidelines for migrating Oracle Advanced queues via exp(dp)/imp(dp)?

edited Aug 28, 2013 4:34AM in Database Utilities (MOSC) 1 commentAnswered
 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    (

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