What happens to index once the table got dropped?

Vaandu picture Vaandu · Dec 8, 2011 · Viewed 33k times · Source

After dropping the table, found that the index created on the columns of the dropped table is gone. I just want to know what happens after that. Could someone please explain?

What all are the others getting dropped along with table drop?

Answer

Raihan picture Raihan · Dec 8, 2011

In Oracle when dropping a table

  • all table indexes and domain indexes are dropped
  • any triggers defined on the table are dropped
  • if table is partitioned, any corresponding local index partitions are dropped
  • if the table is a base table for a view or if it is referenced in a stored procedure, function, or package, then these dependent objects are invalidated but not dropped