DDL TRIGGERS: Oracle is the way.

For a project I’m currently working on I need to use DDL triggers, it seems (at the best of my current understanding) that:

MySQL: no support for DDL triggers yet, they are part of the “remote”
TODOs, we will probable not see them for a long time. ( I tried to
install trigger on the <tt>information_schema</tt> with no results,
since the information_schema is in general a virtual DB.)
DB2: has no direct support for DDL triggers, workaround are possible
using the tracing functionalities http://database.ittoolbox.com/groups/technical-functional/db2-l/ddl-triggers-1147710

. As discussed here also in DB2 triggers on the
<tt>information_schema</tt> are not possible.
Oracle and SQL Server 2005: support DDL triggers.

The server environment we are operating is Linux based, I’ll go for
Oracle.

Here there is a short reference to DDL-triggers in Oracle:
http://www.psoug.org/reference/ddl_trigger.html

 
I will install oracle on the UBUNTU 6.06 LTS server we got at UCLA. This seems a good guide: 
 http://linux.togaware.com/survivor/Oracle_10g.html to install Oracle 10g on
Debian sid. I’m going to use to actually install Oracle 11g on Ubuntu
6.06 LTS.

Leave a Reply

Your email address will not be published. Required fields are marked *