Unable To Create Partitions For Event Tables In Production Environment Using Partition_utils Script (Doc ID 1297458.1)

Last updated on SEPTEMBER 15, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.3.0.0.0 to 7.3.1.0.0 [Release 7.3.0 to 7.3.1]
Information in this document applies to any platform.

Symptoms

When we execute "partition_utils.pl -o add -t realtime -s 01302011 -q 60 -u day -f" command to create realtime partitions, we are getting a PL/SQL error message.

The issue is found in PINDB database of Oracle Communications Billing and Revenue Management when we try to create partitions for event tables in PRODUCTION environment

Error:
SQL*Plus: Release 10.2.0.1.0 - Production on Thu Jan 27 16:18:55 2011

Copyright (c) 1982, 2005, Oracle. All rights reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options

SQL> SQL> SQL> SQL> INFO: Procedure add_partitions_init
Error in populate_partitioning_scheme
ORA-06502: PL/SQL: numeric or value error: character to number conversion error
Error in give_partition_name
Inputs i_curpoid = 263970751596462080 i_tabName = EVENT_T
ORA-01403: no data found
ORA-06503: PL/SQL: Function returned without value
BEGIN PIN_PARTITION.add_partitions_init('bgl-svr-ppba-03','pin', 'pin','/event','01302011',FALSE,2,1,60,2,FALSE,FALSE, 1296125335); END;

*
ERROR at line 1:
ORA-06503: PL/SQL: Function returned without value
ORA-06512: at "PIN.PIN_PARTITION", line 1262
ORA-06512: at line 1

Cause

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