Message-Id: <10647.119117@fatcity.com> From: "Walter K" Date: Thu, 12 Oct 2000 17:23:04 -0500 Subject: How to see DDL executing 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

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.

Any suggestions and/or scripts would be = MUCH=20 appreciated.

-w

------=_NextPart_000_0815_01C03471.14745150--