Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: how to view DDL as it is running
look athe command field of the v$session
corresponding to the session which
is running the sql statement ( select
* from the source table).
The value of command for create table
will be anumber ( find out what it is).
Hence, you know which sessions are
using the create table DDL using
select * from source_table.
Hope this gives some pointers.
Regards
Willy
Received on Wed Apr 11 2001 - 00:13:07 CDT