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


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-01678: parameter string must be pairs of pattern and replacement strings

1 Answers  


NCR-04023: NCRR: Invalid object descriptor

1 Answers  


PCC-02333: SQL identifier was not declared as a statement

1 Answers  


ORA-08499: Warning: picture mask options 'string' ignored by UTL_PG

1 Answers  


RMAN-08589: channel string: starting datafile conversion

1 Answers  






QSM-01522: a more optimal equivlanece than string was used to rewrite

1 Answers  


TNS-00013: INTCTL: error while performing NS disconnect command

1 Answers  


ORA-12021: materialized view "string"."string" is corrupt

1 Answers  


DRG-12218: section group name missing

1 Answers  


NCR-02007: NCRF: Invalid format descriptor received

1 Answers  


ORA-36198: (XSAGGR33) The AGGREGATE operator string does not require a weight, but ARGS variable workspace object specified %4p as a weight.

1 Answers  


TNS-12214: TNS:missing local communities entry in TNSNAV.ORA

1 Answers  






Categories