• Oracle Utilities Smart Grid Gateway Database Administrator’s Guide
• Database Overview
  • Privileges to Modify OUAF V4.5.0.1.1 Database
  • Supported Database Platforms
    • Supported Platforms Summary Table
    • Support for Software Patches and Upgrades
  • Database Maintenance Rules
    • Permitted Database Changes
    • Non-Permitted Database Changes
• Installing the Database
  • Installation Overview
  • Initial Install
    • Copying and Decompressing Install Media
    • Creating the Database
    • Installing the CISADM Schema
    • Post-installation Tasks
  • Upgrade Install
    • Supported Upgrade Paths
    • Copying and Decompressing Install Media
    • 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:
• Information Lifecycle Management and Data Archiving in SGG
  • 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 SGG (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 SGG (Existing Installation)
• Sample SQL for Enabling ILM with Sub Retention in SGG (Existing Installation)
• Sample SQL for Periodic Maintenance
  • Add Partition
  • Archive Partition
  • Restore Partition
• Partitioning and Compression 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 Oracle Utilities Smart Grid Gateway
  • Upgrading from Oracle Utilities Smart Grid Gateway V2.5.0.0.0 to V2.5.0.1.1
    • New Tables
    • New Indexes
    • Dropped Indexes
    • Columns Added
    • Updated Columns (Tables)
  • Upgrading from Oracle Utilities Smart Grid Gateway V2.5.0.1.0 to V2.5.0.1.1
    • New Columns
    • Deleted Columns
    • New Indexes
    • Deleted Indexes
• 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
• 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 Smart Grid Gateway Database Administrator’s Guide

Oracle Utilities Smart Grid Gateway Release 2.5.0.1.1 Database Administrator’s Guide