Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: how to view DDL as it is running

Re: how to view DDL as it is running

From: Uchakra <uchakra_at_aol.com>
Date: 11 Apr 2001 05:13:07 GMT
Message-ID: <20010411011307.25176.00002969@ng-cr1.aol.com>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US