• Oracle Utilities Work and Asset Management Database Administrator’s Guide
• Oracle Utilities Work and Asset Management Database Overview
  • Supported Database Platforms
    • Support for Software Patches and Upgrades
  • Database Maintenance Rules
    • Permitted Database Changes
    • Non-Permitted Database Changes
• Oracle Utilities Work and Asset Management Database Installation Overview
  • Installation Overview
    • Prerequisites
    • Creating the Database
  • Installation Types
    • Initial Install
    • Upgrade Install
    • Demo Install
  • Installation Notes
• Installing the Oracle Utilities Work and Asset Management Database - Initial Installation
  • Copying and Decompressing Install Media
  • Creating the Database
    • Creating the Database on Linux/UNIX
    • Creating the Database on Windows
    • Database Globalization Support Consideration
  • Installing the WAM Schema
    • Installing the Oracle Utilities Application Framework Database Component using OraDBI.jar
    • Installing Oracle Utilities Application Framework Prerequisite Database Single Fixes
    • Installing Database Component using OraDBI.jar
    • Tasks Performed by ORADBI
  • Generating Database Statistics
  • Enable USER_LOCK Package
• Upgrading the Oracle Utilities Work and Asset Management Database
  • Copying and Decompressing Install Media
  • Upgrading the Schema
    • Upgrading the Oracle Utilities Application Framework Database Component using OraDBI.jar
    • Installing Oracle Utilities Application Framework Prerequisite Database Single Fixes
    • Upgrading Oracle Utilities Work and Asset Management Database Component using OraDBI.jar
  • Generating Database Statistics
  • Enable USER_LOCK package
• Installing the Database - Demo Environment
  • Copying and Decompressing Install Media
  • Creating the Database
  • Importing the WAM Demo Dump File
  • Configuring Security
• Database Design
  • Database Object Standard
    • 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
    • Storage Recommendations
    • Database Configuration Recommendations
    • Database Syntax
    • Database Initialization Parameters
  • Oracle Database Implementation Guidelines
    • Oracle Partitioning
    • Database Statistic
    • Materialized View
• Upgrades to the Oracle Utilities Work and Asset Management 2.4.0.0.0 Database
  • Oracle Utilities Work and Asset Management V2.2.0.6.0 to V2.4.0.0.0
    • New Tables
    • Dropped Tables
    • New Fields
    • Updated Fields
    • Dropped Fields
    • New Indexes
    • Updated Indexes
    • Dropped Indexes
    • New Views
    • New Materialized Views
  • Oracle Utilities Work and Asset Management V2.3.0.0.0 to V2.4.0.0.0
    • New Tables
    • Dropped Tables
    • New Fields
    • Updated Fields
    • Dropped Fields
    • New Indexes
    • Updated Indexes
    • Dropped Indexes
    • New Views
    • New Materialized Views
• Upgrades to the Oracle Utilities Application Framework Database
  • Upgrades to Oracle Utilities Application Framework v4.3.0.3.0
  • Upgrades to Oracle Utilities Application Framework v4.3.0.4.0
  • Upgrades to Oracle Utilities Application Framework v4.3.0.5.0
  • Upgrades to Oracle Utilities Application Framework v4.3.0.6.0
  • Upgrades to Oracle Utilities Application Framework v4.4.0.0.0
  • Upgrades to Oracle Utilities Application Framework v4.4.0.2.0
  • Upgrades to Oracle Utilities Application Framework v4.4.0.3.0
  • Upgrades to Oracle Utilities Application Framework v4.5.0.0.0
• 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 Work and Asset Management Database Administrator’s Guide

Oracle Utilities Work and Asset Management Release 2.4.0.0.0 Database Administrator’s Guide