-
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.
-
-
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
<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
-
....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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|