Re: Where is v$sqltext

Leng Kaing (leng_at_cougar.vut.edu.au) wrote:
: Env: Oracle 7.1.3, VMS 6.1
 

: Found something interesting: I can see v$sqltext in sql*dba when
: connected as SYS or SYSTEM. But there is no such object in sql*plus
: when connected as SYS or SYSTEM. I've searched the dictionary,
: dba_segments, dba_objects, all_segments, all_objects but can't find
: the thing. So have you got it in you 7.1.3 database? Where did it come
: from?

Thanks to everyone for your input. Here's what I've learnt: v$sqltext is missing in 7.1.3's catalog.sql and was included in later versions of Oracle - say 7.1.6 and higher. Although you can't describe v$sqltext in sql*plus, you can certainly select from it. You can describe it in SQL*DBA as sql*dba is a special tool that has access to more than the data dictionary.

I shall now endeavour to create the view based on 7.2's catalog.sql (7.2 for unix of course as it will never come to vms :-( )

Leng.

--
Leng Kaing
DBA - Directory Technology P/L
Email: lkaing_at_ventnds1.telecom.com.au
Ph: +61-3-9892-9081  Fax: +61-3-9892-9344
WWW: http://www.vut.edu.au/voug