Billing and Revenue Management (MOSC)

MOSC Banner

Facing issue while executing Purge operation using Partition_utils

edited Jan 9, 2020 12:31AM in Billing and Revenue Management (MOSC) 16 commentsAnswered

Facing issue while executing Purge operation using Partition_utils

sz1234://u01/pin12/opt/portal/7.3/bin> partition_utils.pl -o purge -e 12012015 -t realtime

This process may take several minutes to complete. Please do not abort this process!

In progress...

Begin Time is : 2019/12/23 6:46:43

Executing purge_partitions_init............

ORA-06550: line 1, column 7:

ORA-06550: line 1, column 7:

ERROR(-20099) An Oracle error was encountered.

Look into partition_utils.log for detail error messages

sz1234://u01/pin01/opt/portal/7.3/bin>

When checked in Partition utils Log below error is evident :

SQL> SQL> SQL> SQL> BEGIN PIN_PARTITION.purge_partitions_init('sz1234','pin12', 'pin12','/event', '01011970', '12012015', FALSE, 6, TRUE, 0, 1577080003); END;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center