Oracle Utilities Customer Care and Billing Database Administrator’s Guide

Welcome to the Oracle Utilities Customer Care and Billing Database Administrator’s Guide.

This guide is intended for database administrators who will be installing and maintaining the database for Oracle Utilities Customer Care and Billing.

The following topics are included:

• Database Overview

• Installing the Database

• Database Design

• Database Implementation Guidelines

• Conversion Tools

• Information Lifecycle Management and Data Archiving in CCB

• Sample SQL for Enabling ILM in CCB (Initial Install)

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

• Sample SQL for Periodic Maintenance

• Sample SQL for ILM in CCB

• Sample Scripts for Customer Contact Enhancement

• Upgrades to the Oracle Utilities Customer Care and Billing 2.9.0.0.0 Database

• Upgrades to the Oracle Utilities Application Framework Database

• Oracle Utilities Application Framework System Table Guide