Technical data

i
Contents
Preface................................................................................................................................................................ i-i
Audience ............................................................................................................................................................................ i-i
Related Documents.......................................................................................................................................................... i-i
Updates to this Documentation..................................................................................................................................... i-i
Conventions ..................................................................................................................................................................... i-ii
Chapter 1
Database Overview ............................................................................................................................................ 1-1
Supported Database Platforms..................................................................................................................................... 1-2
Supported Platforms Summary Table......................................................................................................... 1-2
Support for Software Patches and Upgrades............................................................................................. 1-2
Database Maintenance Rules ........................................................................................................................................ 1-3
What Changes Are Permitted....................................................................................................................... 1-3
What Changes Are Not Permitted .............................................................................................................. 1-3
Chapter 2
Database Installation ........................................................................................................................................ 2-1
Installation Overview..................................................................................................................................................... 2-2
Oracle Database Installation......................................................................................................................................... 2-3
Database Scripts and Utilities....................................................................................................................... 2-3
Initial Install .................................................................................................................................................... 2-3
Upgrade Install ............................................................................................................................................... 2-6
Demo Install ................................................................................................................................................... 2-8
Creating the Database ................................................................................................................................... 2-9
Security Configuration................................................................................................................................. 2-11
Populating Language Data.......................................................................................................................... 2-11
Installing Service Packs and Patches......................................................................................................... 2-12
Chapter 3
Database Design ............................................................................................................................................... 3-1
Database Object Standard............................................................................................................................................. 3-2
Categories of Data ......................................................................................................................................... 3-2
Naming Standards.......................................................................................................................................... 3-2
Column Data Type and Constraints............................................................................................................................ 3-6
User Defined Code........................................................................................................................................ 3-6
System Assigned Identifier ........................................................................................................................... 3-6
Date/Time/Timestamp ................................................................................................................................ 3-6
Number ........................................................................................................................................................... 3-6
Fixed Length/Variable Length Character Columns................................................................................. 3-6
Null Column Support.................................................................................................................................... 3-6
Cache and Key Validation Flags.................................................................................................................. 3-6
Default Value Setting..................................................................................................................................... 3-7
Foreign Key Constraints............................................................................................................................... 3-7
Standard Columns .......................................................................................................................................................... 3-7