Re: identify CTAS from v$ tables
- From: Joseph Amalraj <joseph@xxxxxxxxxxxxxx>
- To: ganstadba@xxxxxxxxxxx, joseph@xxxxxxxxxxxxxx
- Date: Tue, 25 Apr 2006 12:37:26 -0700 (PDT)
After going thru' the v$fixed_view_definition for v$sql, v$open_cursor and
v$sqltext, I could only get the name of the table being created by the
following query.
sys@clfypurg> select kglnaobj from x$kgllk where kgllkmod = 3;
KGLNAOBJ
------------------------------------------------------------
MY_LARGE_TABLE
if "alter session set sql_trace = true" is run before executing CTAS the trace
does generate the CTAS sql statement.
Can the sql be found from any x$ table ??
Thanks
Joseph
Michael McMullen <ganstadba@xxxxxxxxxxx> wrote:
Here's what TOAD uses but as I recall you can't get the underlying
DDL statement for CTAS. Maybe changed in 10g.
SELECT sql_text
FROM v$sqltext_with_newlines
WHERE hash_value = TO_NUMBER (:HASH)
ORDER BY piece
Other related posts:
