Check the list of all objects present in Oracle Database.

Find the list of objects present in Oracle Database.

DBA_ refer to all objects in database, ALL_ refer to which object having access privilege’s to user plus own created objects, USER_ refer to only own object created you can see.

SELECT * FROM dba_objects;
OR
SELECT * FROM ALL_OBJECTS;
OR
SELECT * FROM USER_OBJECTS;

Find the objects present in particular schema in Oracle

SELECT * FROM dba_objectw where owner = 'schema_name';

List all the dictionary views:

SELECT * FROM dict;

Find the list of all tables present in Oracle Database

Select * from dba_tables;
OR
SELECT * FROM ALL_TABLES:
OR
SELECT * FROM USER_TABLES;

List of all tables columns in Oracle Database

SELECT * FROM all_tab_columns
 WHERE table_name = :tname;

2 thoughts on “Check the list of all objects present in Oracle Database.

  1. Dave B

    Great work, many thanks!
    I think there is a minor typo though:

    Find the objects present in particular schema in Oracle

    SELECT * FROM dba_objectw where owner = ‘schema_name’;

    should be:
    SELECT * FROM dba_objects where owner = ‘schema_name’;

    Keep up the great work!

    Liked by 1 person

    Reply

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.