Re: identify CTAS from v$ tables

  • From: "Michael McMullen" <ganstadba@xxxxxxxxxxx>
  • To: <joseph@xxxxxxxxxxxxxx>
  • Date: Tue, 25 Apr 2006 14:45:27 -0400

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:

  1. Home
  2. oracle-l
  3. Archive
  4. 04-2006