Show user objects oracle

Hello everyone,

I am a beginner in Oracle and I am stuck on a problem.

Among the users in my Oracle database, there is the user BIACV21ORG,
I would like to display only all the objects (tables, views) that belong to this user only.

Thank you in advance.

1 answer

  • Votes
  • Date
  • Descending date
  1. ```html Under conn / as sysdba

    select * from dba_objects
    where owner = 'BIACV21ORG'
    /


    To make it more readable, if you are not using SQL/Developer or Toad for execution, you can simplify with:

    select OBJECT_TYPE, OBJECT_NAME from dba_objects
    where owner = 'BIACV21ORG'
    /

    (normally I didn't mess up on the column names or the S at the end..
    but just in case, use DESC dba_objects for help;) ```