cannot create QUEUE_TABLE, user does not have access to AQ object types

An attempt was made to issue the CREATE_QUEUE_TABLE command, but the user who issued the command does not have access to internal AQ object types.

How to Solve :

Use the DBMS_AQADM.GRANT_TYPE_ACCESS procedure to grant the user access to the AQ object types.

cannot create QUEUE_TABLE, QUEUE_PAYLOAD_TYPE string.string does not exist

An invalid QUEUE_PAYLOAD_TYPE specified during create_queue_table.

How to Solve :

The QUEUE_PAYLOAD_TYPE should be RAW or an object type that already exists in the database.

cannot create QUEUE_TABLE, user string does not have execute privileges on QUEUE_PAYLOAD_TYPE string.string

An invalid object type specified for QUEUE_PAYLOAD_TYPE during create_queue_table.

The user should have execute priviliges on the object type specified for the queue.

cannot create QUEUE_TABLE, string already exists

The queue table already exists in the queueing system.

Drop the table first using the DROP_QUEUE_TABLE() command or specify another table.