Oracle Utilities Meter Data Management Database Administrator’s Guide

Welcome to the Oracle Utilities Meter Data Management Database Administrator’s Guide. This document provides instructions to install and maintain the database for Oracle Utilities Meter Data Management V2.5.0.1.1.

Quick Links

• Database Overview

• Installing the Database

• Database Design

• Database Implementation Guidelines

• Conversion Tools

• Information Lifecycle Management and Data Archiving in MDM

• Oracle Utilities Meter Data Management Support on ADB

• 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 Enabling ILM in ADB

• 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

For more information, refer to the Oracle Utilities Meter Data Management documentation available on Oracle Help Center at: https://docs.oracle.com/en/industries/energy-water/meter-data-management/index.html

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