My Oracle Support Banner

ERROR(-20019) Observed When Running Partition Utility (Doc ID 1381373.1)

Last updated on SEPTEMBER 10, 2019

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.3.1.0.0 and later
Information in this document applies to any platform.

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 one can see below error message:

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

Question: how  to overcome from this error?

Solution

To view full details, sign in with your My Oracle Support account.

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


In this Document
Goal
Solution


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