Saturday 29 September 2012

Object dropped along with table in oracle


Objects dropped along with table in oracle

Which objects are dropped along with table and which objects become INVALID.

Below are automatically dropped with table.
  1. Table structure
  2. Table data
  3. Indexes on the table
  4. Triggers associated with table
Below objects status becomes invalid.
  1. Views
  2. Procedures
  3. Functions
  4. Packages
  5. Materialized views

No comments:

Post a Comment