ORA-02007: can't use ALLOCATE or DEALLOCATE options with REBUILD



ORA-02007: can't use ALLOCATE or DEALLOCATE options with REBUILD..

Answer / guest

Cause: Allocate or deallocate storage and rebuild index are
not compatible.

Action: Choose one or the other.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

RMAN-07513: List of Files Which Where Not Cataloged

1 Answers  


ORA-24025: invalid value string, QUEUE_PAYLOAD_TYPE should be RAW or an object type

1 Answers  


ORA-29539: Java system classes already installed

1 Answers  


ORA-19757: could not resize change tracking file to string blocks

1 Answers  


ORA-16069: Archive Log standby database activation identifier mismatch

1 Answers  






ORA-06781: TLI Driver: error reading negotation string

1 Answers  


PLS-00417: unable to resolve "string" as a column

1 Answers  


PCB-00008: Must use option SQLCHECK=SEMANTICS(FULL) when there is embedded PL/SQL

1 Answers  


RMAN-08049: channel string: starting compressed archive log backupset

1 Answers  


ORA-08452: specification of E in picture mask is unsupported

1 Answers  


TNS-12226: TNS:operating system resource quota exceeded

1 Answers  


RMAN-08045: channel string: finished piece string at string with string copies

1 Answers  


Categories