Technical data

Database Object Standard

3-4 Oracle Utilities Meter Data Management Database Administrator’s Guide

- <LOB>

- <Column Name>

<TABLESPACE>CISTS_01</TABLESPACE>

</Column Name>

</LOB>

</Table_Name>

Where Parallel defines the number of threads, that Oracle DB Server will use to access a table or

create an index.

For instance, if a DBA decided to allocate table CI_ACCT in a tablespace MyTablespace, then

they would have to change the storage.xml as follows:

<CI_ACCT>

<TABLESPACE>MyTablespace</TABLESPACE>

</CI_ACCT>

The cdxdbi process uses the storage.xml file to place the new database objects into defined

tablespaces. A tablespace referenced in the storage.xml file must exist in the database.

The storage.xml file has to be adjusted before each upgrade and/or new installation as required to

allocate the tables and indexes across those tablespaces.

Table name is included as a comment for each of the indexes for clarity.

For initial installs, information for each object should be reviewed by a DBA. For upgrades, only

tablespace information for the objects added in the new release needs to be reviewed by a DBA.

Be careful while editing this file. Make sure that the tablespace names being used exist in the

database. Do not change the basic format of this file.

Sequence

The base sequence name must be prefixed with the owner flag value of the product.

The sequence numbers should be named as below

1. If the Sequence is used for a specific Table then use the following sequence name:

[OF][C/M/T]NNN_SEQ

• OF stands for Owner Flag. For example, Framework its F1. Other examples are

M1,C1,D1,D2, etc.

• C/M/T stands for Control (Admin)/Master/Transaction Tables.

• NNN is a three digit unique Identifier for a Table on which the Sequence is defined.

For Example: F1T220_SEQ

2. If more than one Sequence is used for a specific Table then use the following Sequence

Name:

[OF][C/M/T]NNN_Column_Name_SEQ

• OF stands for Owner Flag. For example, the framework is F1. Other examples are

M1,C1,D1,D2, etc.

• C/M/T stands for Control (Admin)/Master/Transaction tables.

• NNN is a three digit unique identifier for a table on which the sequence is defined.