How To Create Partitions for /ledger_report (Doc ID 3073869.1)

Last updated on MARCH 03, 2025

Applies to:

Goal

One user has followed the steps mentioned in the document of Converting Additional Nonpartitioned Classes to Partitioned Classes:
https://docs.oracle.com/en/industries/communications/billing-revenue/12.0/sys-admin/converting-nonpartitioned-classes-partitioned-classes1.html#GUID-B92539B3-3441-46D2-96B6-F0F3359CC275

1. Create new ledger_tables_tobe_partitioned.sql

2. Add the new SQL script to the @SQL_PARTITION_TABLES parameter in the BRM_home/upgrade/partition/partition.cfg file.

3. Run perl partitioning.pl
    Creating log directory /opt/rms/opt/brm/brm/12.0/BRM/upgrade/partition/sqllog
    Running all the scripts
    Started pin_upg_common.sql at Tue Jan 7 16:28:47 2025
    Started ledger_tables_tobe_partitioned.sql at Tue Jan 7 16:28:49 2025
    Started make_indexes_partition_ready.sql at Tue Jan 7 16:28:51 2025
    Started optional_partition.sql at Tue Jan 7 16:28:53 2025

4. Run partition_utils

ERROR
-----------------------
[USER@HOST partition_utils]$ partition_utils -o add -t realtime -s 01152025 -q 12 -u month -c /ledger_report -f
This process may take several minutes to complete. Please do not abort this process!
In progress...
Begin Time is : 2025/1/7 16:31:19
Executing add_partitions_init............
ORA-04063: package body "PINDEV2.PIN_PARTITION" has errors
ORA-06508: PL/SQL: could not find program unit being called: "PINDEV2.PIN_PARTITION"
ORA-06512: at line 1
ERROR(-20099) An Oracle error was encountered.

Look into partition_utils.log for detail error messages

Error in another environment:
----------------------------------------------
SQL> SQL> SQL> SQL> INFO: Procedure add_partitions_init
PINPARTITION_ERROR_NO -20001
ORA-20001: Partitioning is not enabled for the given class
BEGIN PIN_PARTITION.add_partitions_init('bhmbssapp3blab','rms', 'PINDEV3','/ledger_report','01152025',0,0,1,12,2,TRUE,TRUE,FALSE,1736368091); END;

*
ERROR at line 1:
ORA-20001: Partitioning is not enabled for the given class
ORA-06512: at "PINDEV3.PIN_PARTITION", line 1869
ORA-06512: at "PINDEV3.PIN_PARTITION", line 85
ORA-06512: at "PINDEV3.PIN_PARTITION", line 1709
ORA-06512: at line 1

Solution

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