Oracle Utilities Customer to Meter Database Administrator’s Guide
Preface
Audience
Related Documents
Updates to this Documentation
Conventions
Acronyms
Additional Resources
Database Overview
Privileges to Modify OUAF V4.5.0.2.0 Database
Supported Database Platforms
Supported Platforms Summary Table
Support for Software Patches and Upgrades
Database Maintenance Rules
Permitted Database Changes
Non-Permitted Database Changes
Installing the C2M 2.9.0.2.0 Database
Installation Overview
Creating the Database
Installing the Oracle Database
Database Scripts and Utilities
Initial Install (Installing V2.9.0.2.0 for the First Time)
Upgrade Install
Demo Install
Database Design
Database Object Standard
Categories of Data
Naming Standards
Column Data Type and Constraints
User Defined Code
System Assigned Identifier
Date/Time/Timestamp
Number
Fixed Length/Variable Length Character Columns
Null Column Support
XML Type Support
Cache and Key Validation Flags
Default Value Setting
Foreign Key Constraints
Standard Columns
Owner Flag
Version
Database Implementation Guidelines
Configuration Guidelines
Index
Table Partitioning Recommendations
Transparent Data Encryption Recommendations
Data Compression Recommendations
Database Vault Recommendations
Oracle Fuzzy Search Support
Storage Recommendations
Database Configuration Recommendations
Database Syntax
Database Initialization Parameters
Oracle Database Implementation Guidelines
Oracle Partitioning
Database Statistic
Materialized View
Conversion Tools
Database Configuration
Installing the Script
Preparing the Production Database
Preparing the Staging Database
• On-premises:
Upgrading the Production Database
Upgrading the Staging Database
Information Lifecycle Management and CCB Data Archiving in C2M
ILM Implementation Overview
ILM Implementation Components
ILM Database Administrator’s Tasks
Preparation Phase
On-going Maintenance Phase
Database Blueprint Installation
Naming Convention
Information Lifecycle Management and MDM Data Archiving in C2M
ILM Implementation Overview
ILM Implementation Components
ILM Database Administrator’s Tasks
Preparation Phase
On-going Maintenance Phase
Naming Convention
Sample SQL for Enabling ILM in C2M for CC&B (Initial Install)
Maintenance Object: TO DO ENTRY
Parent Table: CI_TD_ENTRY
Child Table: CI_TD_DRLKEY
Child Table: CI_TD_ENTRY_CHA
Child Table: CI_TD_LOG
Child Table: CI_TD_MSG_PARM
Child Table: CI_TD_SRTKEY
Maintenance Object:F1-SYNCREQIN
Parent Table: F1_SYNC_REQ_IN
Child Table: F1_SYNC_REQ_IN_CHAR
Child Table: F1_SYNC_REQ_IN_EXCP
Child Table: F1_SYNC_REQ_IN_EXCP_PARM
Child Table: F1_SYNC_REQ_IN_LOG
Child Table: F1_SYNC_REQ_IN_LOG_PARM
Child Table: F1_SYNC_REQ_IN_REL_OBJ
Sample SQL For Enabling ILM in C2M for CCB (Existing Installation)
Sample SQL for Periodic Maintenance for CCB Data
Add Partition
Archive Partition
Restore Partition
Sample SQL for Partitioning with ILM in C2M for CC&B
Maintenance Object: Adjustment
Parent Table: CI_ADJ
Maintenance Object: Bill Segment
Parent Table: CI_BSEG
Sample SQL for Enabling ILM in C2M for MDM (Initial Install)
Maintenance Object: TO DO ENTRY
Parent Table: CI_TD_ENTRY
Child Table: CI_TD_DRLKEY
Child Table: CI_TD_ENTRY_CHA
Child Table: CI_TD_LOG
Child Table: CI_TD_MSG_PARM
Child Table: CI_TD_SRTKEY
Maintenance Object:F1-SYNCREQIN
Parent Table: F1_SYNC_REQ_IN
Child Table: F1_SYNC_REQ_IN_CHAR
Child Table: F1_SYNC_REQ_IN_EXCP
Child Table: F1_SYNC_REQ_IN_EXCP_PARM
Child Table: F1_SYNC_REQ_IN_LOG
Child Table: F1_SYNC_REQ_IN_LOG_PARM
Child Table: F1_SYNC_REQ_IN_REL_OBJ
Maintenance Object: D1-IMD
Parent Table: D1_INIT_MSRMT_DATA
Child Table: D1_INIT_MSRMT_DATA_CHAR
Child Table: D1_INIT_MSRMT_DATA_LOG
Child Table: D1_INIT_MSRMT_DATA_LOG_PARM
Child Table: D1_INIT_MSRMT_DATA_K
Sample SQL For Enabling ILM in C2M for MDM (Existing Installation)
Sample SQL for ILM in C2M with Sub Retention (Existing Installation)
Sample SQL for Periodic Maintenance for MDM Data
Adding Partition
Archiving Partition
Archiving Subpartition
Restoring Partition
Restoring Subpartition
Compressing Partition (D1_MSRMT table only)
Sample Scripts for Customer Contact Enhancement
Updating Customer Contact Account and Premise
Updating Preferred Contact Method on Legacy Values
Partitioning and Compression Recommendations
Partitioning Recommendations
Partitioning Recommendations
D1_MSRMT
D1_MSRMT_CHAR
D1_MSRMT_LOG
D1_MSRMT_LOG_PARM
D1_INIT_MSRMT_DATA
D1_INIT_MSRMT_DATA_CHAR
D1_INIT_MSRMT_DATA_K
D1_INIT_MSRMT_DATA_LOG
D1_INIT_MSRMT_DATA_LOG_PARM
Compression Recommendations
Upgrades to the C2M V2.9.0.2.0 Database
Upgrades to the Oracle Utilities Application Framework Database
Upgrading from Oracle Utilities Application Framework V4.3.0.4.0 to V4.3.0.5.0
Upgrading from Oracle Utilities Application Framework V4.3.0.5.0 to V4.3.0.6.0
Upgrading from Oracle Utilities Application Framework v4.3.0.6.0 to v4.4.0.0.0
Upgrading from Oracle Utilities Application Framework v4.4.0.0.0 to v4.4.0.2.0
Upgrading from Oracle Utilities Application Framework v4.4.0.2.0 to v4.4.0.3.0
Upgrading from Oracle Utilities Application Framework v4.4.0.3.0 to v4.5.0.0.0
Upgrading from Oracle Utilities Application Framework v4.5.0.0.0 to v4.5.0.1.1
Upgrading from Oracle Utilities Application Framework v4.5.0.1.1 to v4.5.0.2.0
Oracle Utilities Customer to Meter System Table Guide
Business Configuration Tables
Installation Options
Oracle Application Framework System Table Guide
About the Application Framework System Tables
System Table Standards
Guidelines for System Table Updates
Business Configuration Tables
Development and Implementation System Tables
System Table List
Sample SQL Script for Interval Partitioning
Oracle Utilities Customer to Meter Database Administrator’s Guide
Oracle Utilities Customer to Meter Release 2.9.0.2.0 Database Administrator’s Guide