My Oracle Support Banner

Information Needed For ILM Table Partitioning for Parent PK Column ID and CHAR / VARCHAR columns (Doc ID 2518705.1)

Last updated on DECEMBER 05, 2019

Applies to:

Oracle Utilities Meter Data Management - Version 2.2.0.3.0 and later
Information in this document applies to any platform.

Goal

Information needed for ILM table partitioning for Oracle Utilities Meter Data Management 2.2.0.3.0. 

For a new MDM database while reviewing MDM DBA Guide, in Appendix A and other locations of this documents, there are sample scripts for reference. Throughout sample scripts, it demonstrated the sub-partition and index partition on the PK column as below for the parent tables, which were all for data type CHAR (14).

The DBA Guide listed all 21 parent tables from ILM modules and most of them are CHAR (14), but there are also 1 of them VARCHAR2 (30), three of them CHAR (12). 

(1) Can I assume the data pattern of all of these 21 parent PK Column IDs are digit format like demonstrated in the sample scripts
(2) For CHAR (12) and VARCHAR(30) may I accordingly adjust the number of the digit by removing two “99”s from the end of the pattern for CHAR(12), and add additional sixteen “9999999999999999” at the end for VARCHAR(30)?
 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.