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-23373: object group "string"."string" does not exist

1 Answers  


ORA-04018: invalid value string for parameter _scn_scheme

1 Answers  


ORA-25149: Columns of UROWID type may not be indexed

1 Answers  


ORA-31059: Cannot insert root XML document node if it already exists

1 Answers  


ORA-29909: label for the ancillary operator is not a literal number

1 Answers  






PLS-00377: internal type PLS_INTEGER is not included in this release of PL/SQL

1 Answers  


ORA-07412: sfaslv: Error getting entry in asynchronous write array.

1 Answers  


NCR-04008: NCRR: Procedure exists

1 Answers  


ORA-23370: table string and table string are not shape equivalent (string)

1 Answers  


RMAN-05512: tablespace string cannot be skipped from duplication

1 Answers  


ORA-01530: a database already mounted by the instance

1 Answers  


ORA-22918: specified column or attribute is not a VARRAY type

1 Answers  


Categories