RE: identify CTAS from v$ tables

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

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