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

Question Posted / guest

1 Answers
4032 Views
I also Faced
E-Mail Answers

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

ORA-01245: offline file string will be lost if RESETLOGS is done

2 Answers

ORA-12841: Cannot alter the session parallel DML state within a transaction

1 Answers

ORA-22927: invalid LOB locator specified

1 Answers

ORA-19924: there are no row with id string

1 Answers

ORA-02796: Done request is not in correct state

1 Answers

TNS-00305: The Navigator encountered an invalid/unknown trace level

1 Answers

ORA-38305: object not in RECYCLE BIN

3 Answers

TNS-12533: TNS:illegal ADDRESS parameters

1 Answers

ORA-22276: invalid locator for LOB buffering

1 Answers

ORA-23425: invalid materialized view identifier string

1 Answers

ORA-31158: schema "string" currently being referenced

1 Answers

TNS-00508: No such protocol adapter

1 Answers

For more Oracle Errors Interview Questions Click Here