Technical data

ii
Owner Flag...................................................................................................................................................... 3-7
Version............................................................................................................................................................. 3-7
Chapter 4
Database Implementation Guidelines.............................................................................................................. 4-1
Configuration Guidelines .............................................................................................................................................. 4-2
Index ................................................................................................................................................................ 4-2
Table Partitioning Recommendations ........................................................................................................ 4-2
Transparent Data Encryption Recommendations.................................................................................... 4-2
Data Compression Recommendations....................................................................................................... 4-3
Database Vault Recommendations ............................................................................................................. 4-3
Storage Recommendations.......................................................................................................................... 4-4
Database Configuration Recommendations .............................................................................................. 4-4
Database Syntax ............................................................................................................................................. 4-5
Database Initialization Parameters .............................................................................................................. 4-5
Appendix A
Upgrades to the Oracle Utilities Meter Data Management Database............................................................ A-1
Automatic Data Upgrade ............................................................................................................................................. A-2
Schema Change.............................................................................................................................................................. A-3
New System Data .......................................................................................................................................................... A-4
Algorithm Type ............................................................................................................................................. A-4
Algorithm ....................................................................................................................................................... A-9
Application Service ..................................................................................................................................... A-17
Batch Control .............................................................................................................................................. A-18
Business Object........................................................................................................................................... A-19
FK Reference............................................................................................................................................... A-23
Lookups........................................................................................................................................................ A-24
Maintenance Object.................................................................................................................................... A-30
Script ............................................................................................................................................................. A-30
To do Type................................................................................................................................................... A-37
Portal............................................................................................................................................................. A-37
Portal Zone .................................................................................................................................................. A-38
UI Map.......................................................................................................................................................... A-40
XAI Inbound Service ................................................................................................................................. A-47
Zone.............................................................................................................................................................. A-47
Appendix B
Upgrades to the Oracle Utilities Application Framework Database .............................................................. B-1
Automatic Data Upgrade ............................................................................................................................................. B-2
Nullable column support ............................................................................................................................. B-2
Schema Change.............................................................................................................................................................. B-2
New Tables .................................................................................................................................................... B-2
New Views ..................................................................................................................................................... B-2
Dropped Tables............................................................................................................................................. B-3
Unsupported Tables ..................................................................................................................................... B-3
Added Columns............................................................................................................................................. B-3
Dropped Columns ........................................................................................................................................ B-3
Unsupported Table Columns...................................................................................................................... B-3
Column Format Change .............................................................................................................................. B-3
New System Data .......................................................................................................................................................... B-4
Algorithm Type ............................................................................................................................................. B-4
Algorithm ....................................................................................................................................................... B-4
Application Service ....................................................................................................................................... B-5
Access Mode Added to Application Service............................................................................................. B-5
Batch Control ................................................................................................................................................ B-5