DBACATALOG, ALLCATALOG, USERCATALOG - Name, type & owner - Oracle Schema

Q.  In Schema Objects Data Dictionary Views which view List the name, type, and owner (USER view does not display owner) for all tables, views, synonyms, and sequences in the database?
- Published on 12 Aug 15

a. DBA_OBJECTS, ALL_OBJECTS, USER_OBJECTS
b. DBA_DEPENDENCIES, ALL_DEPENDENCIES, USER_DEPENDENCIES
c. DBA_CATALOG, ALL_CATALOG, USER_CATALOG
d. None of the above

ANSWER: DBA_CATALOG, ALL_CATALOG, USER_CATALOG

Related Content

 

    Discussion

  • Nirja Shah   -Posted on 25 Sep 15
    - These views display general information about schema objects:

    1. DBA_OBJECTS, ALL_OBJECTS, USER_OBJECTS
    - DBA view describes all schema objects in the database.
    - ALL view describes objects accessible to current user.
    - USER view describes objects owned by the current user.

    2. DBA_CATALOG, ALL_CATALOG, USER_CATALOG
    - List the name, type, and owner (USER view does not display owner) for all tables, views, synonyms, and sequences in the database.

    3. DBA_DEPENDENCIES, ALL_DEPENDENCIES, USER_DEPENDENCIES
    - List all dependencies between procedures, packages, functions, package bodies, and triggers, including dependencies on views without any database links.

➨ Post your comment / Share knowledge


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)
▲