I understand will be able to make use of this to produce DDL create trigger

CREATE OR REPLACE TRIGGER 
  create_table_trigger
  AFTER CREATE ON SCHEMA
DECLARE
BEGIN
END;

Issue is this trigger would operate on DDLs like 'Create sequence' how do i only execute this for 'Create Table' DDLs?

CREATE OR REPLACE TRIGGER 
  create_table_trigger
  AFTER CREATE ON SCHEMA
BEGIN
  IF SYS.DICTIONARY_OBJ_TYPE = 'TABLE' THEN
      ....
END;

For a listing of EVENT characteristics, make reference to this site
http://ist.marshall.edu/ist480adbp/plsql_triggers.html

  • dictionary_obj_type Returns the kind of the dictionary object which the DDL operation that fired the trigger happened.
  • dictionary_obj_title Returns the title from the dictionary object which the DDL operation that fired the trigger happened.