Unable To Remove Or Update Partitions (Doc ID 889196.1)

Last updated on OCTOBER 27, 2015

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.3.0.0.0 and later
Information in this document applies to any platform.
***Checked for relevance on 05-May-2011***
***Checked for relevance on 03-Dec-2012***
*** Checked for relevance on 10-27-2015 ***


Symptoms

Cannot remove or update partitions using the partition_utils.pl script.

$ partition_utils.pl -o remove -s 02082009 -e 05082009 -f -p

Force flag will drop the partitions that lies in the given range without any conditional checking.
Are you sure to drop the partitions?(y/n)y

Force flag will drop the partitions that lies in the given range without any conditional checking.
Are you sure to drop the partitions?(y/n)y
This process may take several minutes to complete. Please do not abort this process!
In progress...
Begin Time is : 2009/9/8 18:5:6
Executing drop_partitions_init............
ORA-00936: missing expression
ERROR(-20099) An Oracle error was encountered.

Look into partition_utils.log for detail error messages


partition_utils.log

SQL> INFO: Procedure drop_partitions_init
Error in populate_partitioning_scheme
ORA-00936: missing expression
INDEX = LOCAL

PL/SQL procedure successfully completed.



partition_utils.pl -o update -c /event -p

This process may take several minutes to complete. Please do not abort this process!
In progress...
Begin Time is : 2009/9/8 12:21:54
Executing update_partitions_init procedure............
ORA-00936: missing expression
ERROR(-20099) An Oracle error was encountered.

Look into partition_utils.log for detail error messages


partition_utils.log

SQL> SQL> SQL> SQL> INFO: Procedure update_partitions_init
INDEX = LOCAL
Error in populate_partitioning_scheme
ORA-00936: missing expression

PL/SQL procedure successfully completed.

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