How to see DDL executing

From: Walter K <alden14004_at_yahoo.com>
Date: Thu, 12 Oct 2000 17:23:04 -0500
Message-Id: <10647.119117@fatcity.com>

This is a multi-part message in MIME format.

------=_NextPart_000_0815_01C03471.14745150 Content-Type: text/plain;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Is there a place where I can see the SQL of DDL statements executing? = For example, if I execute a statement such as CREATE TABLE..AS SELECT.. = I cannot see the SQL in v$sqlarea or v$sqltext. I have a need to monitor = the progress.

Any suggestions and/or scripts would be MUCH appreciated.

-w

------=_NextPart_000_0815_01C03471.14745150 Content-Type: text/html;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 5.50.4207.2601" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Is there a place where I can see the =
SQL of DDL=20
statements executing? For example, if I execute a statement such as = CREATE=20
TABLE..AS SELECT.. I cannot see the SQL in v$sqlarea or v$sqltext. = I have a=20
need to monitor the progress.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Any suggestions and/or scripts would be =
MUCH=20
appreciated.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>-w</FONT></DIV></BODY></HTML>

------=_NextPart_000_0815_01C03471.14745150-- Received on Thu Oct 12 2000 - 17:23:04 CDT