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

PLS-00626: partitioned/clustered/ordered parameter must be a function argument

1 Answers  


ORA-12655: Password check failed

1 Answers  


ORA-32614: illegal MODEL SELECT expression

1 Answers  


ORA-06027: NETASY: channel close failure

1 Answers  


ORA-01743: only pure functions can be indexed

1 Answers  






ORA-00341: log string of thread string, wrong log # string in header

1 Answers  


ORA-26677: Streams downstream capture process string cannot proceed

1 Answers  


ORA-00261: log string of thread string is being archived or modified

1 Answers  


ORA-16232: adding Logical Standby skip entry for table string.string

1 Answers  


QSM-01048: join back level(s) not present (string)

1 Answers  


DRG-12700: seed word must be a single word

1 Answers  


ORA-02236: invalid file name

1 Answers  


Categories