RE: anyway to trace a DDL statement?

bounced the DB. Ran it again and it worked. I was looking at the raw trace file.

thanks guys.

• Original message ---------------------- From: "Cary Millsap" <cary.millsap_at_hotsos.com>
  > Ryan,
  >
  > That sounds pretty weird. All the recursive SQL should be in the trace
  > file. Have you looked at the raw trace data to confirm that it's not
  > there? Or are you by chance looking at your tkprof output (which might
  > be hiding it from you)?
  >
  > Cary Millsap
  > Hotsos Enterprises, Ltd.
  > http://www.hotsos.com
  > Nullius in verba
  >
  > Hotsos Symposium 2008 / March 2-6 / Dallas
  > Visit www.hotsos.com for curriculum and schedule details...
  >
  > -----Original Message-----
  > From: oracle-l-bounce_at_freelists.org
  > [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of
  > ryan_gaffuri_at_comcast.net
  > Sent: Thursday, November 01, 2007 8:32 AM
  > To: oracle-l_at_freelists.org
  > Subject: anyway to trace a DDL statement?
  >
  > If I run a 10046 trace on a DDL statement, I do not get the recursive
  > SQL that oracle runs underneath the DDL. Is there another form of trace
  > that will show me what oracle is doing?
  > --
  > http://www.freelists.org/webpage/oracle-l
  >
  >
  > --
  > http://www.freelists.org/webpage/oracle-l
  >
  >
  

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