ORA-25183: index-organized table top index segment is in a
different tablespace



ORA-25183: index-organized table top index segment is in a different tablespace..

Answer / guest

Cause: An attempt was made to drop a tablespace which
contains an index only table's overflow segment but not the
top index segment"

Action: find index-organized tables which span the
tablespace being dropped and some other tablespace(s). Drop
these tables.

Please add more information about this Error

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-10575: Give up restoring recovered datafiles to consistent state: out of memory

1 Answers  


ORA-01544: cannot drop system rollback segment

1 Answers  


ORA-29830: operator does not exist

1 Answers  


ORA-24162: name value pair list is full, cannot add another entry

1 Answers  


ORA-16051: parameter string contains an invalid delay time

1 Answers  


TNS-00519: Operating system resource quota exceeded

2 Answers  


ORA-09822: Translation of audit file name failed.

1 Answers  


DRG-12409: syntax error for label in string

1 Answers  


LSX-00023: unknown namespace URI "~S"

1 Answers  


ORA-09778: snynfyport: failure allocating the notify port.

1 Answers  


ORA-28109: the number of related policies has exceeded the limit of 16

1 Answers  


ORA-31418: source schema string does not exist

1 Answers  


Categories