RE: identify CTAS from v$ tables

  • From: "Christian Antognini" <Christian.Antognini@xxxxxxxxxxxx>
  • To: <joseph@xxxxxxxxxxxxxx>
  • Date: Tue, 25 Apr 2006 18:14:15 +0200

Joseph

>Please let me know how to identify that a session is executing a
>Create Table As Select from v$ tables

If it's not a problem to get "regular" CREATE TABLE as well, you can use the 
following statement:

SELECT sid FROM v$session WHERE command = 1


HTH
Chris

--
//www.freelists.org/webpage/oracle-l

Other related posts:

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