Oracle Utilities Digital Asset Management Database Administrator’s Guide

Welcome to the Oracle Utilities Digital Asset Management Database Administrator’s Guide. This guide included instructions to install and maintain the database for Oracle Utilities Digital Asset Management V2.0.0.1.3.

Quick Links:

• Database Overview

• Installing the Oracle Utilities Digital Asset Management 2.0.0.1.3 Database

• Database Design

• Database Implementation Guidelines

• Conversion Tools

• Information Lifecycle Management and CCB Data Archiving

• Information Lifecycle Management and MDM Data Archiving

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

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

• Sample SQL for Periodic Maintenance for CCB Data

• Sample SQL for Partitioning with ILM for CCB

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

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

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

• Sample SQL for Periodic Maintenance for MDM Data

• Sample Scripts for Customer Contact Enhancement

• Partitioning and Compression Recommendations

• Oracle Utilities Digital Asset Management System Table Guide

• Oracle Utilities Application Framework System Table Guide

• Sample SQL Script for Interval Partitioning

For more information, refer to the Oracle Utilities Digital Asset Management documentation available on Oracle Help Center at: https://docs.oracle.com/en/industries/energy-water/digital-asset-management/index.html

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