Problem Partitioning ITEM_T Using BRM 7.4

(Doc ID 1104165.1)

Last updated on SEPTEMBER 26, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version to [Release 7.4.0]
Information in this document applies to any platform.
Checked for relevance on 26-Mar-2012
*** Checked for relevance on 02-29-2016 ***


Tried to partition /item using the steps in the BRM documentation.

BRM 7.4 Documentation says:

Partitioning item tables
You might need to partition item tables when upgrading from previous versions. To partition item tables, do the following:
1. Use the pin_deploy utility to export the existing /item storable class definition.
        cd BRM_home/sys/test
        pin_deploy class -mn /item > item.podl
2. Using a text editor, open the item.podl file.
3. Add or modify the following:
        IS_PARTITIONED = "1";
        PARTITION_MODE = "Finite";
    Note The value for PARTITION_MODE could be Finite or Historic depending on the requirement.
4. Save and close the file.
5. Run the following command:
       pin_deploy replace item.podl
    This updates the data dictionary for this class and also creates the basic partitions in the item tables.
6. To partition item tables, run the partition_utils utility with the add operation. The syntax is:
       partition_utils -o add -t realtime|delayed -s start_date -u month|week|day -q quantity
       [-c storable_class] [-w width] [-f] [-p]
For more information, see partition_utils.

On step 5, got this error :

/portal/evolutivo/7.4/sys/test> pin_deploy replace item.podl
Warning: Class Name /item already exists.
field num=<PIN_FLD_IS_PARTITIONED:1,564>

Could not set IS_PARTITIONED for item_t. 

Did not see any change in PARTITIONED field for item class in dd_object table.


Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms