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
Debian sid. I’m going to use to actually install Oracle 11g on Ubuntu
6.06 LTS.