11.2. Working with the Pending Area

Before defining or updating any DRM objects, you must first establish a pending area. A pending area is a staging area where resource management objects can be defined and validated before they are activated. If you forget to create the pending area, you will receive the following error message if you try to create or update a DRM object:

ERROR at line 1:
ORA-29371: pending area is not active
ORA-06512: at "SYS.DBMS_RMIN", line 115
ORA-06512: at "SYS.DBMS_RESOURCE_MANAGER", line 108
ORA-06512: at line 1

The next sections explain how to manage pending areas. You will learn to create, validate, submit, and clear them.

11.2.1. Creating a Pending Area

To create a pending area, simply execute the DBMS_RESOURCE_MANAGER.CREATE_PENDING_AREA ...

Get OCP: Oracle 10g Administration II Study Guide: Exam 1Z0-043 now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.