In this forum you can share stuff related to Oracle 11g, 10g, 9i.
nomi
Posts: 29 Joined: Mon Dec 03, 2007 3:50 am
Location: Pakistan
Post
by nomi » Wed Dec 26, 2007 9:34 am
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
Posts: 29 Joined: Mon Dec 03, 2007 3:50 am
Location: Pakistan
Post
by nomi » Wed Dec 26, 2007 9:41 am
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
Posts: 138 Joined: Sat Apr 08, 2006 5:54 pm
Location: Canada
Contact:
Post
by amirtai » Mon Jan 28, 2008 11:31 pm
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
Posts: 25 Joined: Fri Mar 31, 2006 4:49 pm
Location: United Kingdom
Post
by omerjaved100 » Tue Apr 08, 2008 7:34 am
Hi,
It can be found in sys user as view.
Users browsing this forum: No registered users and 10 guests