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

PLS-00504: type string_BASE may not be used outside of package STANDARD

1 Answers  


ORA-03216: Tablespace/Segment Verification cannot proceed

1 Answers  


ORA-01214: MAXLOGHISTORY may not exceed string

1 Answers  


ORA-30182: invalid precision specifier

1 Answers  


ORA-08447: syntax error in USAGE clause in mask options

1 Answers  






ORA-29894: base or varray datatype does not exist

1 Answers  


ORA-14509: specified VALIDATE INTO table form incorrect

1 Answers  


ORA-26089: LONG column "string" must be specified last

1 Answers  


ORA-30197: reserved for future use

1 Answers  


DRG-50915: last document number string is not an integer

1 Answers  


ORA-12548: TNS:incomplete read or write

1 Answers  


SQL*Loader-00911: Error defining output variable(s) for upi: [number]

1 Answers  


Categories