set echo on

alter trigger auditddl_trg disable
/

drop table audit_ddl
/

create table audit_ddl (
        timestamp       date default sysdate,
        owner           varchar2(20) default user,
        osuser          varchar2(20),
        object          varchar2(30),
        event           varchar2(30),
        type_obj        varchar2(30))
/

create or replace trigger auditddl_trg 
        after truncate or drop or create or comment or grant or revoke on schema
begin
        insert into audit_ddl (osuser, object, event, type_obj ) 
           values (sys_context('USERENV','OS_USER'), ora_dict_obj_name, ora_sysevent, ora_dict_obj_type);
end;
/
set echo off