Where is v$sqltext
From: Leng Kaing <leng_at_cougar.vut.edu.au>
Date: 1996/05/02
Message-ID: <4m8r9e$460_at_cougar.vut.edu.au>#1/1
Date: 1996/05/02
Message-ID: <4m8r9e$460_at_cougar.vut.edu.au>#1/1
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?
TIA,
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/vougReceived on Thu May 02 1996 - 00:00:00 CEST