tailieunhanh - Rampant TechPress Oracle Data Warehouse Management PHẦN 9

Để duy trì một nhóm nhất quán các mục. Những kiểm tra này là mặc nhiên được thực hiện khi khu vực đang chờ được gửi. Lưu ý: Oracle cho phép các nhóm người tiêu dùng "mồ côi" (tức là, nhóm người tiêu dùng không có chỉ thị kế hoạch giới thiệu cho họ). Đây là dự đoán rằng một quản trị viên có thể muốn tạo ra một nhóm khách hàng đó không phải là hiện đang được sử dụng, | ROBO Books Monograph Data Warehousing and Oracle8i order to maintain a consistent group of entries. These checks are also implicitly done when the pending area is submitted. Note Oracle allows orphan consumer groups . consumer groups that have no plan directives that refer to them . This is in anticipation that an administrator may want to create a consumer group that is not currently being used but will be used in the future. The procedure has no arguments. Syntax of the VALIDATE_PENDING_AREA Procedure The VALIDATE_PENDING_AREA procedure is used to validate the contents of a pending area before they are submitted. The procedure has no arguments. Usage Notes For the Validate and Submit Procedures The following rules must be adhered to and they are checked whenever the validate or submit procedures are executed 1. No plan schema may contain any loops. 2. All plans and consumer groups referred to by plan directives must exist. 3. All plans must have plan directives that refer to either plans or consumer groups. 4. All percentages in any given level must not add up to greater than 100 for the emphasis resource allocation method. 5. No plan may be deleted that is currently being used as a top plan by an active instance. 6. For Oracle8i the plan directive parameter parallel_degree_limit_p1 may only appear in plan directives that refer to consumer groups . not at subplans . 7. There cannot be more than 32 plan directives coming from any given plan . no plan can have more than 32 children . 8. There cannot be more than 32 consumer groups in any active plan schema. 9. Plans and consumer groups use the same namespace therefore no plan can have the same name as any consumer group. Page 97 COPYRIGHT 2003 Rampant TechPress. All Rights Reserved. ROBO Books Monograph Data Warehousing and Oracle8i 10. There must be a plan directive for OTHER_GROUPS somewhere in any active plan .