Missing V$SQLTEXT

From: Dr. Blue <ou79138_at_deere.com>
Date: 1996/10/25
Message-ID: <3270B9F1.9B@deere.com>#1/1

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 Received on Fri Oct 25 1996 - 00:00:00 CDT