Module NameTable namePartition type (Oracle)IntervalPartition type (SQL Server)IntervalJob Run Framework

JOB_RUN_EVENT

Range

Daily - Separate partition for data belonging to each distinct date

RangeDaily - Separate partition for data belonging to each distinct date

DEPLOY_JOB_RUN_EVENT

Reference

Inherits the JOB_RUN_EVENT partitioning schemeNANACompliance

COMPLIANCE_RULE_RESULT

Range

Daily - Separate partition for data belonging to each distinct date

RangeDaily - Separate partition for data belonging to each distinct date

COMP_RULE_GROUP_RULE_RESULT

Reference

Inherits the COMPLIANCE_RULE_RESULT partitioning scheme

RangeDaily - Separate partition for data belonging to each distinct date

COMP_ENTRY_RESULT

Reference

Inherits the COMPLIANCE_RULE_RESULT partitioning schemeRangeDaily - Separate partition for data belonging to each distinct date

COMP_ENTRY_RESULT_DETAILS

Reference

Inherits the COMPLIANCE_RULE_RESULT partitioning schemeRangeDaily - Separate partition for data belonging to each distinct date

CR_RULE_RESULT_SELECTOR

Reference

Inherits the COMPLIANCE_RULE_RESULT partitioning schemeNANAPatching

PAJOB_RUN_CATALOG_ASSOC

RangeDaily - Separate partition for data belonging to each distinct dateRangeDaily - Separate partition for data belonging to each distinct date

PATCHING_JOB_RESULTS_ASSOC

RangeDaily - Separate partition for data belonging to each distinct dateRangeDaily - Separate partition for data belonging to each distinct date

PATCHING_JOB_RUN_PART

RangeDaily - Separate partition for data belonging to each distinct dateRangeDaily - Separate partition for data belonging to each distinct date

PAJOB_RUN_CATALOG_ASSOC

RangeDaily - Separate partition for data belonging to each distinct dateRangeDaily - Separate partition for data belonging to each distinct date

PATCHING_JOB_RESULTS_ASSOC

RangeDaily - Separate partition for data belonging to each distinct dateRangeDaily - Separate partition for data belonging to each distinct datePATCH_RMD_DNL_JOB_RUN_ASSOCRangeDaily - Separate partition for data belonging to each distinct dateRangeDaily - Separate partition for data belonging to each distinct datePATCH_CUJ_RESULTRangeDaily - Separate partition for data belonging to each distinct dateRangeDaily - Separate partition for data belonging to each distinct dateBL_PATCH_JOB_RESULT_COUNTRangeDaily - Separate partition for data belonging to each distinct dateRangeDaily - Separate partition for data belonging to each distinct dateBL_PATCH_JOB_RES_PATCH_COUNTRangeDaily - Separate partition for data belonging to each distinct dateRangeDaily - Separate partition for data belonging to each distinct datePATCH_DEPENDENCY_MAPRangeDaily - Separate partition for data belonging to each distinct dateRangeDaily - Separate partition for data belonging to each distinct dateBL_PATCH_ANALYSIS_RES_DATARangeDaily - Separate partition for data belonging to each distinct dateRangeDaily - Separate partition for data belonging to each distinct dateBL_PATCH_RES_DEVICE_CNTRangeDaily - Separate partition for data belonging to each distinct dateRangeDaily - Separate partition for data belonging to each distinct dateBL_PATCH_DOWNLOAD_RES_DATARangeDaily - Separate partition for data belonging to each distinct dateRangeDaily - Separate partition for data belonging to each distinct datePATCH_DOWNLOAD_RESULTRangeDaily - Separate partition for data belonging to each distinct dateRangeDaily - Separate partition for data belonging to each distinct datePATCH_RMD_RESULTRangeDaily - Separate partition for data belonging to each distinct dateRangeDaily - Separate partition for data belonging to each distinct dateRBACROLE_AGG_AUTHRangeInterval partitioning based on ROLE_ID, first partition contains ROLE_ID range from 1 to 1000000 and rest all ROLE_IDs will have separate partitions.RangeInterval partitioning based on ROLE_ID, each ROLE_ID having a separate partitionBL_ACL_POLICY_AGG_AUTHRangeRangeBL_ACL_AGG_AUTHRangeRange