Skip Headers

Oracle® Communications Data Model Reference 11g Release 2 (11.2) Part Number E15886-05 |
Home | Book List | Contents | Index | Contact Us

Previous | Next
| PDF · Mobi · ePub

# 6 Oracle Communications Data Model Partitioning

This chapter provides the partitioning strategy for the Oracle Communications Data Model physical base, derived, and aggregate tables.

This chapter includes the following section:

- Partitioning Strategy for Oracle Communications Data Model

## Partitioning Strategy for Oracle Communications Data Model

Table 6-1 shows the partitioning strategy for the Oracle Communications Data Model physical base, derived, and aggregate tables.

Table 6-1 Physical Data Model Partitioning

Physical Table Name | Partition Key Column | Partition Level | Default Tablespace Name
--- | --- | --- | ---
DWA_ACCT_DEBT_MO | DT | Quarter | TBS_MV
DWA_ACCT_PYMT_MO | DT | Quarter | TBS_MV
DWA_ACCT_PYMT_MTHD_STAT_HIST | DT | Quarter | TBS_MV
DWA_ACCT_RFND_MO | DT | Quarter | TBS_MV
DWA_ACCT_STAT_TYP | DT | Quarter | TBS_MV
DWA_ACCT_STTSTC_TYP | DT | Quarter | TBS_MV
DWA_ARPU_BASE_CUST_TYP | DT | Quarter | TBS_MV
DWA_BER_FER_ERR_RATIO_MO | DT | Quarter | TBS_MV
DWA_CALL_CNTR_CALL_MO | DT | Quarter | TBS_MV
DWA_CALL_CNTR_CASE_MO | DT | Quarter | TBS_MV
DWA_CANBLZTN_DTL_MO | DT | Quarter | TBS_MV
DWA_CELL_STTSTC_MO | DT | Quarter | TBS_MV
DWA_CMISN_MO | DT | Quarter | TBS_MV
DWA_CNCT_DSCNCT_MO | DT | Quarter | TBS_MV
DWA_CNRT_MO | DT | Quarter | TBS_MV
DWA_COST_CUST_MO | DT | Quarter | TBS_MV
DWA_COST_ORG_MO | DT | Quarter | TBS_MV
DWA_CRDT_CTGRY_MO | DT | Quarter | TBS_MV
DWA_CUST_ACQSTN_SUMM_MO | DT | Quarter | TBS_MV
DWA_CUST_DEBT_COLLCTN_MO | DT | Quarter | TBS_MV
DWA_CUST_EQPMNT_INSTLTN_MO | DT | Quarter | TBS_MV
DWA_DATA_USG_MO | DT | Quarter | TBS_MV
DWA_EXTRNL_DEBT_COLLCTN_MO | DT | Quarter | TBS_MV
DWA_GIVE_AWAY_ITEM_MO | DT | Quarter | TBS_MV
DWA_GPRS_PCU_MO | DT | Quarter | TBS_MV
DWA_GPRS_SRVCS_MO | DT | Quarter | TBS_MV
DWA_HNDST_STCK_MO | DT | Quarter | TBS_MV
DWA_HNDST_SUBSDY_MO | DT | Quarter | TBS_MV
DWA_INTRNL_DEBT_COLLCTN_MO | DT | Quarter | TBS_MV
DWA_INVC_ADJ_MO | DT | Quarter | TBS_MV
DWA_INVC_CUST_TYP | DT | Quarter | TBS_MV
DWA_IN_PLTFRM_MO | DT | Quarter | TBS_MV
DWA_LN_ACTVTN_TMNT_MO | DT | Quarter | TBS_MV
DWA_LYLTY_PROG_MO | DT | Quarter | TBS_MV
DWA_MKT_SHARE | DT | Quarter | TBS_MV
DWA_MSC_TRFC_MO | DT | Quarter | TBS_MV
DWA_NBR_PRT_MO | DT | Quarter | TBS_MV
DWA_NTWK_AVLBLTY_MO | DT | Quarter | TBS_MV
DWA_NTWK_TCHPNT_MO | DT | Quarter | TBS_MV
DWA_PRPD_ACCT_STTSTC_SGMNT | DT | Quarter | TBS_MV
DWA_PRPD_ALWNCE_MO | DT | Quarter | TBS_MV
DWA_PRPD_CALL_SUMM_MO | DT | Quarter | TBS_MV
DWA_PRTNR_STLMNT_MO | DT | Quarter | TBS_MV
DWA_PYMT_AGNG_MO | DT | Quarter | TBS_MV
DWA_RDMPTN_MO | DT | Quarter | TBS_MV
DWA_RF_NTWK_CPCTY_MO | DT | Quarter | TBS_MV
DWA_SBCRBR_CHRN_STTSTC_MO | DT | Quarter | TBS_MV
DWA_SHARED_PKG_USG_STTSTC_MO | DT | Quarter | TBS_MV
DWA_SHOP_EFFNCY_MO | DT | Quarter | TBS_MV
DWA_SL_CMPGN_SUMM_MO | DT | Quarter | TBS_MV
DWA_SL_MO | DT | Quarter | TBS_MV
DWA_SPLMNTR_SRVC_USG_MO | DT | Quarter | TBS_MV
DWA_SUBSDY_AMT_MO | DT | Quarter | TBS_MV
DWA_VAS_SBRP_QCK_SUMM_MO | DT | Quarter | TBS_MV
DWA_VAS_USG_MO | DT | Quarter | TBS_MV
DWA_VOI_CALL_MO | DT | Quarter | TBS_MV
DWB_ACCS_MTHD_PORT_HIST | ACT_CTVR_DT | MONTH | TBS_BASE
DWB_ACCS_MTHD_STAT_HIST | EFF_FROM_DT | MONTH | TBS_BASE
DWB_ACCT_BAL_HIST | BAL_DT | MONTH | TBS_BASE
DWB_ACCT_COST | INCURR_DT | MONTH | TBS_BASE
DWB_ACCT_CRDT_LMT | EFF_FROM_DT | MONTH | TBS_BASE
DWB_ACCT_MNGMNT_HIST | ASGN_STRT_DT | MONTH | TBS_BASE
DWB_ACCT_PMP_PRTCPTN_HIST | RLTN_STRT_DT | MONTH | TBS_BASE
DWB_ACCT_PYMT | PYMT_DT | MONTH | TBS_BASE
DWB_ACCT_PYMT_MTHD_STAT | EFF_FROM_DT | MONTH | TBS_BASE
DWB_ACCT_RFND | PYMT_DT | MONTH | TBS_BASE
DWB_ACCT_STAT_HIST | EFF_FROM_DT | MONTH | TBS_BASE
DWB_APNMNT_CLNDR | DAY_KEY | DAY | TBS_BASE
DWB_BLK_LST_HIST | EFF_FROM_DT | MONTH | TBS_BASE
DWB_BRDBND_USG_EVT | EVT_BEGIN_DT | DAY | TBS_BASE
DWB_BSNS_UNIT_COST | INCURR_DT | MONTH | TBS_BASE
DWB_CELL_SITE_COST | INCURR_DT | MONTH | TBS_BASE
DWB_CHNL_COST | INCURR_DT | MONTH | TBS_BASE
DWB_CMPGN_COST | INCURR_DT | MONTH | TBS_BASE
DWB_CMPGN_MSG_CRTVE | CRTN_DT | MONTH | TBS_BASE
DWB_CNCT_LST_COST | INCURR_DT | MONTH | TBS_BASE
DWB_CNRT_APRVL | CNRT_APRVL_DT | MONTH | TBS_BASE
DWB_CNRT_STAT | EFF_FROM_DT | MONTH | TBS_BASE
DWB_CNRT_TERM_VAL | TERM_PRD_STRT_DT | MONTH | TBS_BASE
DWB_CNTNT_DLVRY_EVT | EVT_BEGIN_DT | DAY | TBS_BASE
DWB_COST | INCURR_DT | MONTH | TBS_BASE
DWB_COST_CNTR_BDGT | EFF_FROM_DT | MONTH | TBS_BASE
DWB_CRCUT_RNTL | EFF_FROM_DT | MONTH | TBS_BASE
DWB_CRCUT_TRFC | EFF_STRT_DT | MONTH | TBS_BASE
DWB_CUST_COST | INCURR_DT | MONTH | TBS_BASE
DWB_CUST_FLD_INSTLTN | FLD_ACTVTY_STRT_DT | MONTH | TBS_BASE
DWB_CUST_FLD_SPPRT | FLD_ACTVTY_STRT_DT | MONTH | TBS_BASE
DWB_CUST_FLD_SRVC_ACTVTY | FLD_ACTVTY_STRT_DT | MONTH | TBS_BASE
DWB_CUST_FLD_SRVC_DTL | ACTN_DT | MONTH | TBS_BASE
DWB_CUST_ORDR | ORGNL_ORDR_DT | MONTH | TBS_BASE
DWB_CUST_ORDR_LN_ITEM | ORGNL_ORDR_DT | MONTH | TBS_BASE
DWB_CUST_ORDR_LN_ITEM_ST_ASGN | ORDR_LN_ITEM_STATE_BEGIN_DT | MONTH | TBS_BASE
DWB_CUST_ORDR_PYMT | PYMT_DT | MONTH | TBS_BASE
DWB_CUST_ORDR_STATE_ASGN | ORDR_STATE_BEGIN_DT | MONTH | TBS_BASE
DWB_DATA_SRVC_EVT | EVT_BEGIN_DT | DAY | TBS_BASE
DWB_DEBT_COLLCTN | INTRACN_THRD_STRT_DT | MONTH | TBS_BASE
DWB_DEBT_COLLCTN_ASGN | ASGN_DT | MONTH | TBS_BASE
DWB_DEBT_COLLCTN_ASGN_BTCH | ASGN_DT | MONTH | TBS_BASE
DWB_EMP_ACT_LBR_HRLY | DAY_KEY | DAY | TBS_BASE
DWB_EMP_ACT_LBR_SALARIED | DAY_KEY | DAY | TBS_BASE
DWB_EMP_COST | INCURR_DT | MONTH | TBS_BASE
DWB_EMP_TRNG_REC | TRNG_STRT_DT | MONTH | TBS_BASE
DWB_EQPMNT_CNTR_COST | INCURR_DT | MONTH | TBS_BASE
DWB_EQPMNT_INSTNC_STAT_HIST | EFF_BEGIN_DT | MONTH | TBS_BASE
DWB_EVT | STRT_DT | DAY | TBS_BASE
DWB_EVT_ACCS_MTHD_ACTVTY | STRT_DT | DAY | TBS_BASE
DWB_EVT_ACCT | STRT_DT | MONTH | TBS_BASE
DWB_EVT_ASGN | EFF_FROM_DT | DAY | TBS_BASE
DWB_EVT_COST | INCURR_DT | MONTH | TBS_BASE
DWB_EVT_CRCUT_RNTL | STRT_DT | MONTH | TBS_BASE
DWB_EVT_EMP_PYRL | STRT_DT | MONTH | TBS_BASE
DWB_EVT_EQPMNT_INSTNC | STRT_DT | MONTH | TBS_BASE
DWB_EVT_FINCL | STRT_DT | MONTH | TBS_BASE
DWB_EVT_GEO | STRT_DT | MONTH | TBS_BASE
DWB_EVT_GFT_RDMPTN | STRT_DT | MONTH | TBS_BASE
DWB_EVT_INVC_DLVRY | STRT_DT | MONTH | TBS_BASE
DWB_EVT_LYLTY_PROG | STRT_DT | MONTH | TBS_BASE
DWB_EVT_LYLTY_PROG_ACMLTN | STRT_DT | MONTH | TBS_BASE
DWB_EVT_LYLTY_PROG_RDMPTN | STRT_DT | MONTH | TBS_BASE
DWB_EVT_PROD_PKG | STRT_DT | MONTH | TBS_BASE
DWB_EVT_PRPD_MBL | STRT_DT | MONTH | TBS_BASE
DWB_EVT_PRTY_ASGN | EFF_DT | DAY | TBS_BASE
DWB_EVT_PRTY_INTRACN | STRT_DT | MONTH | TBS_BASE
DWB_EVT_PRTY_INTRACN_CALL | STRT_DT | MONTH | TBS_BASE
DWB_EVT_PRTY_INTRACN_EML | STRT_DT | MONTH | TBS_BASE
DWB_EVT_PRTY_INTRACN_LTTR | STRT_DT | MONTH | TBS_BASE
DWB_EVT_PRTY_INTRACN_VST | STRT_DT | MONTH | TBS_BASE
DWB_EVT_PRTY_PRFL | STRT_DT | MONTH | TBS_BASE
DWB_EVT_SBRP | STRT_DT | MONTH | TBS_BASE
DWB_EVT_SBRP_CHNG | STRT_DT | MONTH | TBS_BASE
DWB_EVT_SIM_CARD | STRT_DT | MONTH | TBS_BASE
DWB_EVT_STAT | EFF_FROM_DT | DAY | TBS_BASE
DWB_EVT_WEB_RGSTRN | STRT_DT | MONTH | TBS_BASE
DWB_FIXED_LN_CALL_EVT | EVT_BEGIN_DT | DAY | TBS_BASE
DWB_IDD_CALL_EVT | EVT_BEGIN_DT | MONTH | TBS_BASE
DWB_INTRNT_ACCS_EVT | EVT_BEGIN_DT | MONTH | TBS_BASE
DWB_INVC | BLLG_DT | MONTH | TBS_BASE
DWB_INVC_ADJ | STRT_DT | MONTH | TBS_BASE
DWB_INVC_DISC | BLLG_DT | MONTH | TBS_BASE
DWB_INVC_ITEM | BLLG_DT | MONTH | TBS_BASE
DWB_INVC_ITEM_DTL | BLLG_DT | MONTH | TBS_BASE
DWB_INVC_PYMT_ASGN | EFF_FROM_DT | MONTH | TBS_BASE
DWB_ISP_USG_EVT | EVT_BEGIN_DT | MONTH | TBS_BASE
DWB_LYLTY_PROG_PTS_BAL | EFF_FROM_DT | MONTH | TBS_BASE
DWB_MDTD_CALL_EVT | EVT_BEGIN_DT | DAY | TBS_BASE
DWB_MEDIA_OBJ_COST | INCURR_DT | MONTH | TBS_BASE
DWB_MKT_PLN_MGMT | MNG_ACTN_DT | MONTH | TBS_BASE
DWB_MMS_EVT | EVT_BEGIN_DT | DAY | TBS_BASE
DWB_MNT_ALLWNC | BAL_DT | MONTH | TBS_BASE
DWB_NP_RQST_HDR | APLCTN_DT | MONTH | TBS_BASE
DWB_NP_RQST_LN_ITEM | NP_STEP_STRT_DT | MONTH | TBS_BASE
DWB_NP_RQST_LN_ITEM_STATE_HIST | EFF_FROM_DT | MONTH | TBS_BASE
DWB_NP_RQST_STATE_HIST | EFF_FROM_DT | MONTH | TBS_BASE
DWB_NTWK_ELMNT_COST | INCURR_DT | MONTH | TBS_BASE
DWB_NTWK_EVT | EVT_BEGIN_DT | DAY | TBS_BASE
DWB_NTWK_FLT | OPEN_DT | MONTH | TBS_BASE
DWB_PRMTN_COST | INCURR_DT | MONTH | TBS_BASE
DWB_PRMTN_MGMT_HIST | EFF_FROM_DT | MONTH | TBS_BASE
DWB_PRMTN_TERM_VAL | TERM_PRD_STRT | MONTH | TBS_BASE
DWB_PROD_COST | INCURR_DT | MONTH | TBS_BASE
DWB_PROD_MKT_PLN_COST | INCURR_DT | MONTH | TBS_BASE
DWB_PRPD_RCHRG | PYMT_DT | MONTH | TBS_BASE
DWB_PRTY_AM_PMP_ASGN_HIST | ASGN_BEGIN_DT | MONTH | TBS_BASE
DWB_PRTY_AM_PMP_ASGN_STAT | ASGN_BEGIN_DT | MONTH | TBS_BASE
DWB_PRTY_INTRACN_THRD | INTRACN_THRD_STRT_DT | MONTH | TBS_BASE
DWB_PRTY_ORDR_ASGN | EFF_FROM_DT | MONTH | TBS_BASE
DWB_PRTY_PRMTN_RESPN | RESPN_DT | MONTH | TBS_BASE
DWB_PRTY_STAT_HIST | EFF_FROM_DT | MONTH | TBS_BASE
DWB_PTV_FULL_CHNL_ACTVTN | EVT_BEGIN_DT | MONTH | TBS_BASE
DWB_PTV_QPI_SRVC_EVT | EVT_BEGIN_DT | MONTH | TBS_BASE
DWB_PTV_USG_EVT | EVT_BEGIN_DT | MONTH | TBS_BASE
DWB_SBRP_STAT_HIST | EFF_FROM_DT | MONTH | TBS_BASE
DWB_SBRP_TERM_VAL | TERM_PRD_STRT_DT | MONTH | TBS_BASE
DWB_SL_CMISN_DTL | EFF_FROM_DT | MONTH | TBS_BASE
DWB_SL_CMISN_PYRL | PAY_DT | MONTH | TBS_BASE
DWB_SMS_EVT | EVT_BEGIN_DT | DAY | TBS_BASE
DWB_SRVC_RQST | INTRACN_THRD_STRT_DT | MONTH | TBS_BASE
DWB_UMS_EVT | EVT_BEGIN_DT | DAY | TBS_BASE
DWB_VNDR_APNMNT | VNDR_APNMNT_DT | MONTH | TBS_BASE
DWB_VOIP_CALL_EVT | EVT_BEGIN_DT | DAY | TBS_BASE
DWB_WRLS_CALL_EVT | EVT_BEGIN_DT | DAY | TBS_BASE
DWB_WRLS_CNTNT_DNLDG_EVT | EVT_BEGIN_DT | MONTH | TBS_BASE
DWD_ACCT_DEBT_DAY | MO_KEY | MONTH | TBS_DERIVED
DWD_ACCT_PYMT_DAY | MO_KEY | MONTH | TBS_DERIVED
DWD_ACCT_PYMT_MTHD_STAT_HIST | MO_KEY | MONTH | TBS_DERIVED
DWD_ACCT_RFND_DAY | MO_KEY | MONTH | TBS_DERIVED
DWD_ACCT_STAT | MO_KEY | MONTH | TBS_DERIVED
DWD_ACCT_STTSTC | MO_KEY | MONTH | TBS_DERIVED
DWD_ARPU_BASE | MO_KEY | MONTH | TBS_DERIVED
DWD_BER_FER_ERR_RATIO_DAY | MO_KEY | MONTH | TBS_DERIVED
DWD_CALL_CNTR_CALL_DAY | MO_KEY | MONTH | TBS_DERIVED
DWD_CALL_CNTR_CASE_DAY | MO_KEY | MONTH | TBS_DERIVED
DWD_CANBLZTN_DTL_DAY | MO_KEY | MONTH | TBS_DERIVED
DWD_CELL_STTSTC_DAY | MO_KEY | MONTH | TBS_DERIVED
DWD_CHRN_PRDCT_SRC | MO_KEY | MONTH | TBS_DERIVED
DWD_CMISN_DAY | MO_KEY | MONTH | TBS_DERIVED
DWD_CNCT_DSCNCT_DAY | DAY_KEY | DAY | TBS_DERIVED
DWD_CNRT | MO_KEY | MONTH | TBS_DERIVED
DWD_CNRT_CHNG | MO_KEY | MONTH | TBS_DERIVED
DWD_COST_CUST | MO_KEY | MONTH | TBS_DERIVED
DWD_COST_ORG | MO_KEY | MONTH | TBS_DERIVED
DWD_CRDT_CTGRY | MO_KEY | MONTH | TBS_DERIVED
DWD_CUST_ACQSTN_SUMM_DAY | MO_KEY | MONTH | TBS_DERIVED
DWD_CUST_DEBT_COLLCTN | MO_KEY | MONTH | TBS_DERIVED
DWD_CUST_EQPMNT_INSTLTN_DAY | MO_KEY | MONTH | TBS_DERIVED
DWD_DATA_USG_DAY | DAY_KEY | DAY | TBS_DERIVED
DWD_EXTRNL_DEBT_COLLCTN_DAY | MO_KEY | MONTH | TBS_DERIVED
DWD_GIVE_AWAY_ITEM_DAY | MO_KEY | MONTH | TBS_DERIVED
DWD_GPRS_PCU_DAY | MO_KEY | MONTH | TBS_DERIVED
DWD_GPRS_SRVCS_DAY | MO_KEY | MONTH | TBS_DERIVED
DWD_HNDST_STCK_DAY | MO_KEY | MONTH | TBS_DERIVED
DWD_HNDST_SUBSDY_DAY | MO_KEY | MONTH | TBS_DERIVED
DWD_INTRNL_DEBT_COLLCTN_DAY | MO_KEY | MONTH | TBS_DERIVED
DWD_INVC | MO_KEY | MONTH | TBS_DERIVED
DWD_INVC_ADJ | MO_KEY | MONTH | TBS_DERIVED
DWD_IN_PLTFRM_DAY | MO_KEY | MONTH | TBS_DERIVED
DWD_LN_ACTVTN_TMNT_DAY | MO_KEY | MONTH | TBS_DERIVED
DWD_LYLTY_PROG_DAY | MO_KEY | MONTH | TBS_DERIVED
DWD_MKT_OPRTR_PRTNG | MO_KEY | MONTH | TBS_DERIVED
DWD_MKT_SHARE | MO_KEY | MONTH | TBS_DERIVED
DWD_MSC_TRFC_DAY | MO_KEY | MONTH | TBS_DERIVED
DWD_NBR_PRT_DAY | MO_KEY | MONTH | TBS_DERIVED
DWD_NTWK_AVLBLTY_DAY | MO_KEY | MONTH | TBS_DERIVED
DWD_NTWK_TCHPNT | MO_KEY | MONTH | TBS_DERIVED
DWD_PRPD_ACCT_STTSTC | MO_KEY | MONTH | TBS_DERIVED
DWD_PRPD_ALWNCE_DAY | MO_KEY | MONTH | TBS_DERIVED
DWD_PRPD_CALL_SUMM_DAY | DAY_KEY | DAY | TBS_DERIVED
DWD_PRTNR_STLMNT | MO_KEY | MONTH | TBS_DERIVED
DWD_PYMT_AGNG_DAY | MO_KEY | MONTH | TBS_DERIVED
DWD_RDMPTN_DAY | MO_KEY | MONTH | TBS_DERIVED
DWD_RF_NTWK_CPCTY_DAY | MO_KEY | MONTH | TBS_DERIVED
DWD_SBCRBR_CHRN_STTSTC | MO_KEY | MONTH | TBS_DERIVED
DWD_SHARED_PKG_USG_STTSTC_DAY | MO_KEY | MONTH | TBS_DERIVED
DWD_SHOP_EFFNCY_DAY | MO_KEY | MONTH | TBS_DERIVED
DWD_SL_CMPGN_SUMM_DAY | MO_KEY | MONTH | TBS_DERIVED
DWD_SL_DAY | MO_KEY | MONTH | TBS_DERIVED
DWD_SL_RPRSTV_STTSTC | MO_KEY | MONTH | TBS_DERIVED
DWD_SPLMNTR_SRVC_USG | MO_KEY | MONTH | TBS_DERIVED
DWD_SUBSDY_AMT | MO_KEY | MONTH | TBS_DERIVED
DWD_VAS_SBRP_QCK_SUMM | MO_KEY | MONTH | TBS_DERIVED
DWD_VAS_USG_DAY | DAY_KEY | DAY | TBS_DERIVED
DWD_VOI_CALL_DAY | DAY_KEY | DAY | TBS_DERIVED