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

NID-00132: CHECKPOINT_CHANGE# in datafile "string": string in the future of controlfile: string

1 Answers  


ORA-01942: IDENTIFIED BY and EXTERNALLY cannot both be specified

1 Answers  


ORA-00230: operation disallowed: snapshot controlfile enqueue unavailable

3 Answers  


PCC-02433: Invalid host variable and attribute pairing

1 Answers  


RMAN-06498: skipping datafile string; already backed up string time(s)

1 Answers  






ORA-29391: %s and string must be mandatory to create a mandatory plan directive

1 Answers  


ORA-25449: invalid variable name: string

1 Answers  


NZE-28766: failure to terminate use of data source

1 Answers  


ORA-13751: "SQL Tuning Set" "string" does not exist or user "string" is not the owner of the "SQL Tuning Set".

1 Answers  


ORA-12927: RETENTION option already specified

1 Answers  


ORA-24763: transaction operation cannot be completed now

1 Answers  


ORA-07261: spdde: kill error, unable to send signal to process.

1 Answers  


Categories