Partitioned sales_data table error when running table_reorg in Demantra
We have Demantra 12.2.5.1 version installed and we are trying to run reorg on sales_data table using below query.
EXEC table_reorg.reorg('DMPLAN','SALES_DATA', 'C', 20, 8);
We are facing following error. The table is partitioned on yearly basis. The reorg is working fine for mdp_matrix table.
ORA-00900: invalid SQL statement
ORA-06512: at "DEMANTRA.TABLE_REORG", line 1386
ORA-00907: missing right parenthesis
ORA-06512: at line 1
00900. 00000 - "invalid SQL statement"
Any help would be highly appreciated.