Oracle Solution for Error ora-30564
ORA-30564: Index maintainence clause not allowed for ADD partition to RANGE partitioned tables
What triggered the Error:
The clause INVALIDATE or UPDATE GLOBAL INDEXES is allowed only for ADD partition to a HASH partitioned table or ADD subpartition to a composite partitioned table.What should we do to fix it:
Remove clause and reissue operation
If this was not sufficient go over to:
Oracle Official Support Knowledge Center
Or maybe those geeks at: StackOverflow Board
Or maybe those geeks at: StackOverflow Board
