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

TNS-00141: Failed to get file stream information

1 Answers  


ORA-24170: %s.string is created by AQ, cannot be dropped directly

1 Answers  


DRG-50701: error in listener.get_cmd()

1 Answers  


RMAN-06520: archived logs required to recover from this backup will not be kept

1 Answers  


TNS-00041: INTCTL: Navigator already running. Start operation cancelled

1 Answers  






ORA-23445: missing template site

1 Answers  


ORA-01596: cannot specify system in string parameter

1 Answers  


UDE-00006: failed to allocate memory of size number

1 Answers  


NID-00480: Database is intact - database is ready to be open or shut down.

1 Answers  


ORA-01255: cannot shutdown - file string in recovery manager backup

1 Answers  


ORA-10638: Index status is invalid

1 Answers  


TNS-12639: Authentication service negotiation failed

1 Answers  


Categories