DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Metatables

  1. #1
    Join Date
    Apr 2005


    Hi Friends,

    Can any one of you let me know where i can find all the objects created using a table (i.e views,mviews etc.)


  2. #2
    Join Date
    Aug 2002
    Colorado Springs
    They are documented in the Database Reference at http://tahiti.oracle.com.

    There are a lot of system views involved, and they are generally prefixed with USER_ (objects that you own), ALL_ (objects that you have access to) and DBA_ (all objects).

    Common views you'd use frequently would be user_tables, user_indexes, user_tab_columns, user_source, user_segments, user_objects, user_tablespaces etc.. See the docs for more details.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  3. #3
    Join Date
    Feb 2005
    If you are interested in what objects have been created that use a particular table, then look at USER_DEPENDENCIES (or DBA_DEPENDENCIES if other uses may have create view, packages etc which use your tables).

    You may need a CONNECT BY query if you want to report on, for example, a package calling a view using the table.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.