View original (French)

Show user objects oracle

bbikuku Posted messages 20 Registration date   Status Member Last intervention   -  
Forghy Posted messages 71 Registration date   Status Member Last intervention   -
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

  1.
    Forghy Posted messages 71 Registration date   Status Member Last intervention   17
     
    ```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;) ```
    2