:

RSSResource Manager

ORA-29381: plan/consumer_group referred to by another plan and cannot be deleted

The Problem When attempting to delete a consumer group from your resource manager configuration, you receive the following error message: EXEC DBMS_RESOURCE_MANAGER.CLEAR_PENDING_AREA; PL/SQL procedure successfully completed. EXEC DBMS_RESOURCE_MANAGER.CREATE_PENDING_AREA; PL/SQL procedure successfully completed. EXEC DBMS_RESOURCE_MANAGER.DELETE_CONSUMER_GROUP(CONSUMER_GROUP=>’REPORTING_GROUP’); BEGIN DBMS_RESOURCE_MANAGER.DELETE_CONSUMER_GROUP(CONSUMER_GROUP=>’REPORTING_GROUP’); END; * ERROR at line 1: ORA-29381: plan/consumer_group REPORTING_GROUP referred to by another plan and cannot be deleted ORA-06512: […]

Continue Reading