ERROR(-20019) Observed When Running Partition Utility

(Doc ID 1381373.1)

Last updated on SEPTEMBER 24, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.3.1.0.0 and later
Information in this document applies to any platform.
***Checked for relevance on 28-May-2013***
***Checked for relevance on 22-Jan-2015***

Goal


ERROR(-20019) was observed when partitioning journal_t, item_t tables using the partition_utils.pl


Steps to Reproduce:
1.System date is ‘Fri Nov 11 12:16:20 mal 2011’ and pvt time is ‘mode 0 1320984993 Fri Nov 11 12:16:33 2011’

2.Run following command:
a.partition_utils.pl -o add -t realtime -s 12012011 -u month -q 12 -c /journal –p
or
b.partition_utils.pl -o add -t realtime -s 12012011 -u month -q 12 -c /journal -f –p

3.In both cases, error message is:


This process may take several minutes to complete. Please do not abort this process!
In progress...
Begin Time is : 2011/11/11 12:4:53
Executing add_partitions_init............
ERROR(-20019) Some indexes are partitioned and some are not.
Look into partition_utils.log for detail error messages



Solution

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