Demantra Solutions - EBS (MOSC)

MOSC Banner

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.

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

EBS Demantra Tags

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center