Re: Missing V$SQLTEXT

Dr. Blue wrote:
>
> I inherited sometime ago two Oracle 7.1 instances.
> The test instance had (V_$SQLTEXT) and I simply created
> the synonym V$SQLTEXT.
>
> The production instance does not have either view and I
> don't know how to create it. I did a grep on the rdbms/admin
> scripts to see if CATALOG or similar had something related
> to SQLTEXT but I could not find it.
>
> Any ideas? I am trying to get the full text of some SQL
> statements that are giving us trouble.
>
> Richard

Try this
drop synonym v$sqltext;
create synonym v$sqltext for sys.v_$sqltext ;

-- 
Steve Harville
Oracle DBA / Unix System Administrator
Fleetguard, Inc.
1200 Fleetguard Rd.
Cookeville, TN 38506
(615) 528-9465 (voice)
(615) 528-9583 (fax)
jsharville_at_fleetguard.com