Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

PCC-00132: Indicator array size must not be less than its host variable

1 Answers  


ORA-01312: Specified table/column does not exist

1 Answers  


PCC-02327: struct or struct pointer required

1 Answers  


ORA-27192: skgfcls: sbtclose2 returned error - failed to close file

1 Answers  


IMP-00061: Warning: Object type "string"."string" already exists with a different identifier

1 Answers  






ORA-00391: All threads must switch to new log format at the same time

1 Answers  


ORA-22804: remote operations not permitted on object tables or user-defined type columns

1 Answers  


ORA-33217: (CINSERT20) Custom member values cannot be added to concat dimension workspace object, or to any of its bases, because it is not defined as UNIQUE.

1 Answers  


ORA-07211: slgcs: gettimeofday error, unable to get wall clock.

1 Answers  


TNS-00507: Connection closed

1 Answers  


ORA-13608: The task or object name string is invalid.

1 Answers  


ORA-09215: sfqio: error detected in IOCompletionRoutine

1 Answers  






Categories