| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> comp.databases.oracle -> List of all views created upon a specific table
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.
-- CristianReceived on Mon Nov 13 2006 - 10:18:30 CST
![]() |
![]() |