Re: DDL Trigger

edmond wrote:
> For Oracle 9iR2.
>
> A simple question for triggers related to DDL statement e.g. create table.
> Is a new transaction always created for the DDL trigger? I,
> disappointingly, cannot find related information in Tahiti's documentation
> and my logical deduction is that since the DDL always commit any existing
> transaction, the trigger should run on a newly created transaction. Am I
> correct? Where could I find more information related to this?

No. DDL triggers run like any other trigger.

But DDL statements, themselves, take the form of:

BEGIN
   COMMIT;
   CREATE TABLE t ....
   COMMIT;
END;
/

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)