dba_tab_cols

[nomi]

Dear Gurus,

Can anybody please suggest in which schema i will find the DBA view <b>dba_tab_cols</b> . i have tried with apps user, but it doesn't recognize table name.



Regards,

Naveed

[nomi]

Thanks all,
I have solved it, infact in our version of oracle it was dba_tab_columns not dba_tab_cols, residing in SYS schema

[amirtai]

Hi

select owner,OBJECT_name,object_type
from all_objects
where object_name='DBA_TAB_COLS' and object_type='VIEW'


OWNER OBJECT_NAME OBJECT_TYPE
------------------------------ ------------------------------ ------------
SYS DBA_TAB_COLS VIEW


Thanks
Amir

[omerjaved100]

Hi,

It can be found in sys user as view.