ORA-28031: maximum of 148 enabled roles exceeded
ORA-06512: at "SYS.DBMS_RULEADM_INTERNAL", line 28
ORA-06512: at "SYS.DBMS_RULE_ADM", line 138
ORA-06512: at "SYS.DBMS_PRVTAQIS",line 2938
ORE-00904: "QT"."USER_PROP":invalid identifier
How can I recreate the queue tables on the 10.2.0.1 database?
Running those two scripts should recreate the AQ tables.
Dig Deeper on Oracle database administration
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.