Oracle Utilities Market Settlements Management Database Administrator’s Guide

Welcome to the Oracle Utilities Market Settlements Management Database Administrator’s Guide. This document provides instructions to install and maintain the Oracle Utilities Market Settlements Management database for 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 MSM

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

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

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

• Sample SQL for Periodic Maintenance

• Partitioning and Compression Recommendations

• Sample SQL Script for Interval Partitioning

• Database Changes in MSM

• Upgrades to the Oracle Utilities Application Framework Database

• Oracle Application Framework System Table Guide

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