Oracle Utilities Customer to Meter Database Administrator’s Guide

Welcome to the Oracle Utilities Customer to Meter Database Administrator’s Guide. This document is intended for database administrators who will be installing and maintaining the database for Oracle Utilities Customer to Meter V2.9.0.1.1.

Quick Links

• Database Overview

• Installing the C2M 2.9.0.1.1 Database

• Database Design

• Database Implementation Guidelines

• Conversion Tools

• Information Lifecycle Management and CCB Data Archiving in C2M

• Information Lifecycle Management and MDM Data Archiving in C2M

• Sample SQL for Enabling ILM in C2M for CC&B (Initial Install)

• Sample SQL For Enabling ILM in C2M for CCB (Existing Installation)

• Sample SQL for Periodic Maintenance for CCB Data

• Sample SQL for Partitioning with ILM in C2M for CC&B

• Sample SQL for Enabling ILM in C2M for MDM (Initial Install)

• 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

• Sample Scripts for Customer Contact Enhancement

• Partitioning and Compression Recommendations

• Upgrades to the C2M V2.9.0.1.1 Database

• Upgrades to the Oracle Utilities Application Framework Database

• Oracle Utilities Customer to Meter System Table Guide

• Oracle Application Framework System Table Guide

• Sample SQL Script for Interval Partitioning

For more information, see the Oracle Utilities Customer to Meter documentation available on Oracle Help Center at: https://docs.oracle.com/en/industries/energy-water/ccb/index.html

Have a question? Contact your Delivery Team or visit My Oracle Support.