ORA-30564: Index maintainence clause not allowed for ADD
partition to RANGE partitioned tables



ORA-30564: Index maintainence clause not allowed for ADD partition to RANGE partitioned tables..

Answer / guest

Cause: 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.

Action: Remove clause and reissue operation

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-19617: file string contains different resetlogs data

1 Answers  


LSX-00320: missing required elements in <all>

1 Answers  


ORA-16725: the phase supplied to resource manager is invalid

1 Answers  


ORA-12222: TNS:no support is available for the protocol indicated

1 Answers  


NCR-03023: NCRO: Cannot receive the break

1 Answers  






DRG-11223: Third-party filter indicates this document is password protected or encrypted.

1 Answers  


DGM-16901: Unable to initialize environment

1 Answers  


ORA-01157: cannot identify/lock data file string - see DBWR trace file

1 Answers  


ORA-23387: replication parallel push dequeue error

1 Answers  


ORA-39114: Dump files are not supported for string jobs

1 Answers  


ORA-00072: process "string" is not active

1 Answers  


TNS-00201: Unable to read answer connection data :string:

1 Answers  


Categories