Oracle Utilities Market Settlements Management Database Administrator’s Guide
Preface
Audience
Related Documents
Updates to this Documentation
Conventions
Acronyms
Additional Resources
Database Overview
Privileges to Modify OUAF V25.4 Database
Supported Database Platforms
Prerequisite Software for Database Server
Database Maintenance Rules
Permitted Database Changes
Non-Permitted Database Changes
Installing the Database
Installation Overview
Initial Install
Copying and Decompressing Install Media
Database Globalization Support Consideration
Creating the Database
Installing the CISADM Schema
Post-installation Tasks
Upgrade Install
Supported Upgrade Path
Copying and Decompressing Install Media
Excluding Table/Index
Installing the CISADM Schema
Post-installation Tasks
Demo Install
Copying and Decompressing Install Media
Creating the Database and Importing the Dump File
Post-installation Tasks
Database Design
Database Object Standards
Categories of Data
Naming Standards
Column Data Type and Constraints
User Defined Code
System Assigned Identifier
Date/Time/Timestamp
Number
Fixed Length/Variable Length Character Columns
Null Column Support
XML Type Support
Cache and Key Validation Flags
Table Classification and Table Volume Flags
Default Value Setting
Foreign Key Constraints
Standard Columns
Owner Flag
Version
Database Implementation Guidelines
Configuration Guidelines
Index
Table Partitioning Recommendations
Transparent Data Encryption Recommendations
Data Compression Recommendations
Database Vault Recommendations
Oracle Fuzzy Search Support
Information Lifecycle Management (ILM) and Data Archiving Support
Storage Recommendations
ILM Enabled Tablespace Requirements
Database Configuration Recommendations
Database Syntax
Database Initialization Parameters
Oracle Database Implementation Guidelines
Oracle Partitioning
Database Statistic
Materialized View
Conversion Tools
Database Configuration
Installing the Script
Preparing the Production Database
Preparing the Staging Database
Linux/UNIX:
• On-premises:
Upgrading the Production Database
Upgrading the Staging Database
Information Lifecycle Management and Data Archiving in MSM
ILM Implementation Overview
ILM Implementation Components
ILM Database Administrator’s Tasks
Preparation Phase
Statistics Snapshot
On-going Maintenance Phase
Naming Convention
Sample SQL for Enabling ILM in MSM (Initial Installation)
Maintenance Object: TO DO ENTRY
Parent Table: CI_TD_ENTRY
Child Table: CI_TD_DRLKEY
Child Table: CI_TD_ENTRY_CHA
Child Table: CI_TD_LOG
Child Table: CI_TD_MSG_PARM
Child Table: CI_TD_SRTKEY
Maintenance Object:F1-SYNCREQIN
Parent Table: F1_SYNC_REQ_IN
Child Table: F1_SYNC_REQ_IN_CHAR
Child Table: F1_SYNC_REQ_IN_EXCP
Child Table: F1_SYNC_REQ_IN_EXCP_PARM
Child Table: F1_SYNC_REQ_IN_LOG
Child Table: F1_SYNC_REQ_IN_LOG_PARM
Child Table: F1_SYNC_REQ_IN_REL_OBJ
Maintenance Object: D1-IMD
Parent Table: D1_INIT_MSRMT_DATA
Child Table: D1_INIT_MSRMT_DATA_CHAR
Child Table: D1_INIT_MSRMT_DATA_LOG
Child Table: D1_INIT_MSRMT_DATA_LOG_PARM
Child Table: D1_INIT_MSRMT_DATA_K
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
Adding Partition
Archiving Partition
Archiving Subpartition
Restoring Partition
Restoring Subpartition
Compressing Partition (D1_MSRMT table only)
Partitioning and Compression Recommendations
Partitioning Recommendations
Partitioning Recommendations
D1_MSRMT
D1_MSRMT_CHAR
D1_MSRMT_LOG
D1_MSRMT_LOG_PARM
D1_INIT_MSRMT_DATA
D1_INIT_MSRMT_DATA_CHAR
D1_INIT_MSRMT_DATA_K
D1_INIT_MSRMT_DATA_LOG
D1_INIT_MSRMT_DATA_LOG_PARM
Compression Recommendations
Sample SQL Script for Interval Partitioning
Database Changes in MSM
Upgrading from Oracle Utilities Market Settlements Management V2.3.0.2.0 to V24.5
New Tables
Dropped Tables
New Views
Deleted Views
New Indexes
Added Columns
Dropped Columns
Upgrading from Oracle Utilities Market Settlements Management V2.5.0.1.1 to V25.4
New Tables
New Indexes
New Columns
Updated Columns
Dropped Columns
Dropped Indexes
Renamed Indexes
Dropped Primary Keys
New Views
Upgrades to the Oracle Utilities Application Framework Database
Upgrading from Oracle Utilities Application Framework V4.3.0.1.0 to V4.3.0.4.0
Upgrading from Oracle Utilities Application Framework V4.3.0.2.0 to V4.3.0.4.0
Upgrading from Oracle Utilities Application Framework V4.3.0.3.0 to V4.3.0.4.0
Upgrading from Oracle Utilities Application Framework V4.3.0.4.0 to V4.3.0.5.0
Upgrading from Oracle Utilities Application Framework V4.3.0.5.0 to V4.3.0.6.0
Upgrading from Oracle Utilities Application Framework V4.3.0.6.0 to V4.4.0.0.0
Upgrading from Oracle Utilities Application Framework V4.4.0.0.0 to V4.4.0.2.0
Upgrading from Oracle Utilities Application Framework V4.4.0.2.0 to V4.4.0.3.0
Upgrading from Oracle Utilities Application Framework V4.4.0.3.0 to V4.5.0.0.0
Upgrading from Oracle Utilities Application Framework V4.5.0.0.0 to V4.5.0.1.1
Upgrading from Oracle Utilities Application Framework V4.5.0.1.1 to V25.4
Oracle Application Framework System Table Guide
About the Application Framework System Tables
System Table Standards
Guidelines for System Table Updates
Business Configuration Tables
Development and Implementation System Tables
System Table List
Oracle Utilities Market Settlements Management Database Administrator’s Guide
Oracle Utilities Market Settlements Management Release 25.4 Database Administrator’s Guide