Data dict. info

[ora_inf]

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.

[gpsingh]

dict or dictionary

[yenni143]

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)

[ora_inf]

I tried both but I got the same result.

[ora_inf]

I don't see anything in comment column.

[Oracledba8]

Hey Try the
Dict_Columns, That stores the all columns and Comments on those Columns

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

Thanks

[sreddy]

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>

[scorpio4u]

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

[ora_inf]

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.

[Oracledba8]

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