Partition Creation for /journal class

Jun 11, 2019 1:38AM

Hi,

I am trying to create parttions for Journal_t in test environment with belwo command -

nohup partition_utils.pl -c /journal -o add -t realtime -s 07012019 -u month -q 3 -f &

On execution I am getting following error in Partition_utils log.

SQL*Plus: Release 11.2.0.4.0 Production on Mon Jun 10 15:30:24 2019

Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning and Automatic Storage Management options

SQL> SQL> SQL> SQL> INFO: Procedure add_partitions_init
PINPARTITION_ERROR_NO -20019
ORA-20019: Some indexes are partitioned and some are not
BEGIN PIN_PARTITION.add_partitions_init('sz4235','', 'pin01','/journal','07012019',FALSE,0,1,3,2,TRUE,TRUE,FALSE,1560173424); END;

Billing and Revenue Management (MOSC)

Partition Creation for /journal class

Howdy, Stranger!

Category Leaderboard

Top contributors this month