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-36403: (XSBADSPROP) number is an illegal value for system-reserved property string on workspace object.

1 Answers  


ORA-01295: DB_ID mismatch between dictionary string and logfiles

1 Answers  


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

1 Answers  


TNS-00137: Failed to get TNS error message file entry

1 Answers  


ORA-07715: sksadtd: could not dismount archival device (SYS$DISMNT failure)

1 Answers  






ORA-12656: Cryptographic checksum mismatch

1 Answers  


ORA-12817: parallel query option must be enabled

1 Answers  


ORA-06733: TLI Driver: failed to receive disconnect

1 Answers  


ORA-32016: parameter "string" cannot be updated in SPFILE

1 Answers  


KUP-04071: record discarded from file string

1 Answers  


ORA-00166: remote/local nesting level is too deep

1 Answers  


ORA-37082: Invalid percent

1 Answers  


Categories