Transcription
Oracle Utilities Meter Data ManagementDatabase Administrator GuideRelease 2.2.0 Service Pack 3E98968-01September 2018(Updated March 2020)
Oracle Utilities Meter Data Management Database Administrator Guide for Release 2.2.0 Service Pack 3Copyright 2000, 2019 Oracle and/or its affiliates. All rights reserved.This software and related documentation are provided under a license agreement containing restrictions onuse and disclosure and are protected by intellectual property laws. Except as expressly permitted in yourlicense agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license,transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverseengineering, disassembly, or decompilation of this software, unless required by law for interoperability, isprohibited.The information contained herein is subject to change without notice and is not warranted to be error-free. Ifyou find any errors, please report them to us in writing.If this is software or related documentation that is delivered to the U.S. Government or anyone licensing it onbehalf of the U.S. Government, then the following notice is applicable:U.S. GOVERNMENT END USERS: Oracle programs, including any operating system, integrated software,any programs installed on the hardware, and/or documentation, delivered to U.S. Government end users are"commercial computer software" pursuant to the applicable Federal Acquisition Regulation and agencyspecific supplemental regulations. As such, use, duplication, disclosure, modification, and adaptation of theprograms, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, shall be subject to license terms and license restrictions applicable to the programs. Noother rights are granted to the U.S. Government.This software or hardware is developed for general use in a variety of information management applications.It is not developed or intended for use in any inherently dangerous applications, including applications thatmay create a risk of personal injury. If you use this software or hardware in dangerous applications, then youshall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safeuse. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this softwareor hardware in dangerous applications.Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks oftheir respective owners.Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks areused under license and are trademarks or registered trademarks of SPARC International, Inc. AMD, Opteron,the AMD logo, and the AMD Opteron logo are trademarks or registered trademarks of Advanced MicroDevices. UNIX is a registered trademark of The Open Group.This software or hardware and documentation may provide access to or information about content, products,and services from third parties. Oracle Corporation and its affiliates are not responsible for and expresslydisclaim all warranties of any kind with respect to third-party content, products, and services unless otherwiseset forth in an applicable agreement between you and Oracle. Oracle Corporation and its affiliates will not beresponsible for any loss, costs, or damages incurred due to your access to or use of third-party content,products, or services, except as set forth in an applicable agreement between you and Oracle.
ContentsPreface. i-iRelated Documents . i-iiUpdates to this Documentation . i-iiConventions. i-iiAcronyms. i-iiiAdditional Resources . i-iiiChapter 1Database Overview . 1-1Prerequisite Software for Database Server . 1-2Permitted Database Changes. 1-3Non-Permitted Database Changes . 1-3Chapter 2Installing the Database. 2-1Copying and Decompressing Install Media . 2-3Database Globalization Support Consideration. 2-3Creating the Database. 2-5Installing the CISADM Schema. 2-6Post-installation Tasks. 2-12Supported Upgrade Path. 2-14Pre-installation Tasks. 2-14Copying and Decompressing Install Media . 2-14Installing the CISADM Schema. 2-14Post-installation Tasks. 2-21Copying and Decompressing Install Media . 2-23Creating the Database and Importing the Dump File. 2-23Chapter 3Database Design . 3-1Database Object Standards . 3-2Categories of Data. 3-2Naming Standards . 3-2Column Data Type and Constraints . 3-5User Defined Code . 3-5System Assigned Identifier . 3-6Date/Time/Timestamp . 3-6Number. 3-6Fixed Length/Variable Length Character Columns . 3-6Null Column Support . 3-6XML Type Support. 3-7Cache and Key Validation Flags . 3-7Table Classification and Table Volume Flags. 3-7Contents - iOracle Utilities Meter Data Management Database Administrator Guide
Default Value Setting.Foreign Key Constraints .Standard Columns .Owner Flag.Version.3-73-73-83-83-8Chapter 4Database Implementation Guidelines. 4-1Index . 4-2Table Partitioning Recommendations. 4-2Transparent Data Encryption Recommendations . 4-2Data Compression Recommendations . 4-3Database Vault Recommendations . 4-7Oracle Fuzzy Search Support. 4-7Information Lifecycle Management (ILM) and Data Archiving Support . 4-8Storage Recommendations . 4-8Database Configuration Recommendations . 4-9Database Syntax. 4-9Database Initialization Parameters . 4-9Oracle Database Implementation Guidelines . 4-10Oracle Partitioning . 4-10Database Statistic. 4-10Materialized View. 4-11Chapter 5Information Lifecycle Management and Data Archiving in MDM . 5-1ILM Implementation Overview . 5-2ILM Implementation Components . 5-2ILM Database Administrator’s Tasks. 5-3Preparation Phase. 5-3On-going Maintenance Phase . 5-41Naming Convention. 5-43Appendix ASample SQL for Enabling ILM in MDM (Initial Installation) . A-1Maintenance Object: TO DO ENTRY . A-1Parent Table: CI TD ENTRY . A-1Child Table: CI TD DRLKEY . A-3Child Table: CI TD ENTRY CHA. A-4Child Table: CI TD LOG. A-4Child Table: CI TD MSG PARM . A-5Child Table: CI TD SRTKEY . A-5Parent Table: F1 SYNC REQ IN . A-6Child Table: F1 SYNC REQ IN CHAR. A-9Child Table: F1 SYNC REQ IN EXCP . A-9Child Table: F1 SYNC REQ IN EXCP PARM. A-10Child Table: F1 SYNC REQ IN LOG . A-10Child Table: F1 SYNC REQ IN LOG PARM. A-11Child Table: F1 SYNC REQ IN REL OBJ . A-11Parent Table: D1 INIT MSRMT DATA. A-12Child Table: D1 INIT MSRMT DATA CHAR . A-16Child Table: D1 INIT MSRMT DATA LOG. A-17Child Table: D1 INIT MSRMT DATA LOG PARM . A-17Child Table: D1 INIT MSRMT DATA K . A-18Contents - iiOracle Utilities Meter Data Management Database Administrator Guide
Appendix BSample SQL for Enabling ILM in MDM (Existing Installation) . B-1Appendix CSample SQL for Enabling ILM with Sub Retention in MDM (Existing Installation) . C-1Appendix DSample SQL for Periodic Maintenance .Adding Partition.Archiving Partition .Archiving Subpartition.Restoring Partition.Restoring Subpartition .Compressing Partition (D1 MSRMT table only).D-1D-2D-2D-5D-7D-8D-9Appendix EPartitioning and Compression Recommendations . E-1Partitioning Recommendations .
Oracle Utilities Meter Data Management Database Administrator Guide Release 2.2.0 Service Pack 3 E98968-01 September 2018 (Updated March 2020)
