Oracle Utilities Work and Asset Management Database Administrator’s Guide
Oracle Utilities Work and Asset Management Database Overview
Privileges to Modify OUAF V4.4.0.1.1 Database
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
Conversion Tools
Database Configuration
Installing the Script
Preparing the Production Database
Preparing the Staging Database
1. Set JAVA_HOME, PATH, and CLASSPATH.
1. Set JAVA_HOME, PATH, and CLASSPATH.
2. Run Conversion from any directory making sure Step 1 is complete. Run the command as necessary.
Linux/UNIX:
Upgrades to the Oracle Utilities Work and Asset Management 2.4.0.1.1 Database
Oracle Utilities Work and Asset Management V2.3.0.0.0 to V2.4.0.1.1
Oracle Utilities Work and Asset Management V2.4.0.0.0 to V2.4.0.1.1
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
Upgrades to Oracle Utilities Application Framework 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 Work and Asset Management Database Administrator’s Guide
Oracle Utilities Work and Asset Management Release 2.4.0.1.1 Database Administrator’s Guide