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