Data dict. info
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: Data dict. info

  1. #1
    Join Date
    Jan 2001
    Posts
    230

    Question

    Hi:

    Which system table will give me the information about system table_name and it's description?
    I tried table called "dictonary" but I was just able to find the table name but not it's discription.

    Let me know.

    Thanks.

  2. #2
    Join Date
    Feb 2001
    Posts
    389
    dict or dictionary

  3. #3
    Join Date
    Feb 2001
    Posts
    114
    SQL> desc dictionary
    Name Null? Type
    ------------------------------- -------- ----
    TABLE_NAME VARCHAR2(30)
    COMMENTS VARCHAR2(4000)

    SQL> desc dict
    Name Null? Type
    ------------------------------- -------- ----
    TABLE_NAME VARCHAR2(30)
    COMMENTS VARCHAR2(4000)

  4. #4
    Join Date
    Jan 2001
    Posts
    230
    I tried both but I got the same result.

  5. #5
    Join Date
    Jan 2001
    Posts
    230
    I don't see anything in comment column.

  6. #6
    Join Date
    Feb 2001
    Posts
    184
    Hey Try the
    Dict_Columns, That stores the all columns and Comments on those Columns

    Desc Dict_Columns
    ----------------------
    TABLE_NAME
    COLUMN_NAME
    COMMENTS

    Thanks

  7. #7
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    I don't understand why you are not getting info from dict columns

    <font face=courier>
    SQL> select * from dict where table_name like 'DBA_%'
    2 /


    TABLE_NAME COMMENTS
    ------------------------- ------------------------------------------------------------
    DBA_2PC_NEIGHBORS information about incoming and outgoing connections for pend
    ing transactions

    DBA_2PC_PENDING info about distributed transactions awaiting recovery
    DBA_ALL_TABLES Description of all object and relational tables in the datab
    ase

    DBA_ANALYZE_OBJECTS
    DBA_ASSOCIATIONS All associations
    DBA_AUDIT_EXISTS Lists audit trail entries produced by AUDIT NOT EXISTS and A
    UDIT EXISTS

    DBA_AUDIT_OBJECT Audit trail records for statements concerning objects, speci
    fically: table, cluster, view, index, sequence, [public] da
    tabase link, [public] synonym, procedure, trigger, rollback
    segment, tablespace, role, user
    </font>
    Reddy,Sam

  8. #8
    Join Date
    Feb 2001
    Posts
    2

    Red face

    ....exactly what are u looking for in the information regarding the table.....blocks?....free extents?....owner....what exactly..u have to be clear...

  9. #9
    Join Date
    Jan 2001
    Posts
    230
    I am looking for the information as sreddy metioned.

    It worked for
    select * from dict where table_name like '%DBA_%'

    but does not work for
    select * from dict where table_name like '%PART%'

    Any idea?

    Thanks.

  10. #10
    Join Date
    Feb 2001
    Posts
    184
    You are Trying to find the User Columns, in Divtionary there will not be any User Tables etc.

    You need to Explore DBA_Objects or All_Objects

    Select * from Dba_Objects
    where Object_Name like '%PART%';

    This should be fine for you.

    Thanks

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