ORA-25189: illegal ALTER TABLE option for an index-organized
table



ORA-25189: illegal ALTER TABLE option for an index-organized table..

Answer / guest

Cause: During ALTER of a index-organized table, the user
attempted to enter one or more of the following options:
TABLESPACE, ALLOCATE/DEALLOCATE EXTENT, PCTFREE/PCTUSED for
IOT top index segment

Action: Remove the illegal option(s).

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-12591: TNS:event signal failure

1 Answers  


ORA-36972: (XSRELTBL13) Relation workspace object must be dimensioned by workspace object.

1 Answers  


DRG-12412: missing or invalid Template Processor attribute (string)

1 Answers  


ORA-06746: TLI Driver: cannot alloc t_call

1 Answers  


LPX-00651: VM Stack overflow.

1 Answers  






ORA-30449: syntax error in parameter string

1 Answers  


ORA-02158: invalid CREATE INDEX option

1 Answers  


PLS-00211: CASE labels or ranges must not be duplicated in different WHEN clauses

1 Answers  


SQL*Loader-00708: Internal error: unknown status number returned from sllf layer

1 Answers  


ORA-19666: cannot do incremental restore of the controlfile

1 Answers  


SQL-02109: Inconsistent host cache. Host reference is out of range

1 Answers  


ORA-27146: post/wait initialization failed

1 Answers  


Categories