Facing issue while executing Purge operation using Partition_utils
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;