ORA-24048: cannot create QUEUE_TABLE, user does not have
access to AQ object types



ORA-24048: cannot create QUEUE_TABLE, user does not have access to AQ object types..

Answer / guest

Cause: 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.

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

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-16717: clearing parameter LOG_ARCHIVE_DUPLEX_DEST failed

1 Answers  


TNS-00137: Failed to get TNS error message file entry

1 Answers  


ORA-27207: syntax error in device PARMS - parentheses mismatch or missing

1 Answers  


ORA-08207: ora_addr: cannot open address file

1 Answers  


ORA-00976: LEVEL, PRIOR, or ROWNUM not allowed here

2 Answers  






NNL-00556: set|show reset_stats_interval [<seconds>] [<server_list>] : set|show server statistic counter reset interval

1 Answers  


QSM-02151: subquery or named view in FROM list and < 9.0 compatibility

1 Answers  


ORA-12986: columns in partially dropped state. Submit ALTER TABLE DROP COLUMNS CONTINUE

1 Answers  


ORA-01486: size of array element is too large

1 Answers  


ORA-02198: ONLINE/OFFLINE option already specified

1 Answers  


ORA-00040: active time limit exceeded - call aborted

1 Answers  


RMAN-20241: ambiguous archived log name

1 Answers  


Categories