Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.oracle -> List of all views created upon a specific table

List of all views created upon a specific table

From: Kristian <cristian_at_katamail.com>
Date: Mon, 13 Nov 2006 16:18:30 GMT
Message-ID: <qV06h.4565$mZ5.4074@tornado.fastwebnet.it>


Let's say I have three database users:

user_a has a table called table_a upon which user_b and user_c create their corresponding views:

I'd like to know if there's an easy way to get a list of all the views in a database instance which were created upon a given owner/table.

This would help me to avoid dropping a database user who has tables that other database users depend on.

-- 
Cristian
Received on Mon Nov 13 2006 - 10:18:30 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US