Data dict. info

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.

dict or dictionary

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)

I tried both but I got the same result.

I don't see anything in comment column.

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

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

Thanks

I don't understand why you are not getting info from dict columns


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

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

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.

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

I am trying to find out the purpose of system partition table/index.

for an example
USER_PART_INDEXES
USER_IND_PARTITIONS

I don't see anything in the comment in the dict for this.

Let me know.

Thanks.