Oracle Utilities Meter Data Management Database Administrator’s Guide

Oracle Utilities Meter Data Management Database Administrator’s Guide

Welcome to the Oracle Utilities Meter Data Management Database Administrator’s Guide.

This guide provides instructions to install and maintain the database for Oracle Utilities Meter Data Management, including:

• Database Overview

• Installing the Database

• Database Design

• Database Implementation Guidelines

• Conversion Tools

• Information Lifecycle Management and Data Archiving in MDM

• Sample SQL for Enabling ILM in MDM (Initial Installation)

• Sample SQL for Enabling ILM in MDM (Existing Installation)

• Sample SQL for Enabling ILM with Sub Retention in MDM (Existing Installation)

• Sample SQL for Periodic Maintenance

• Partitioning and Compression Recommendations

• Database Changes in MDM

• Upgrades to the Oracle Utilities Application Framework Database

• Oracle Application Framework System Table Guide

• Sample SQL Script for Interval Partitioning