Database Administration (MOSC)

MOSC Banner

How can one predict which objects will get invalidated when a index is dropped?

edited Jul 4, 2010 11:23PM in Database Administration (MOSC) 12 commentsAnswered
How can one predict which objects will get invalidated when a index is dropped?

Below is a simple testcase. Could not get this information  from dependency$ and the *_dependencies views.

Thx in advance.

 C:\>sqlplus "/ as sysdba"

SQL*Plus: Release 11.2.0.1.0 Production on Fri Jul 2 11:59:01 2010

Copyright (c) 1982, 2010, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining,
Oracle Database Vault and Real Application Testing options

SQL> DROP USER METALINK CASCADE
  2  ;
DROP USER METALINK CASCADE
          *
ERROR at line 1:
ORA-01918: user 'METALINK' does not exist


SQL> CREATE USER METALINK IDENTIFIED BY METALINK

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center