No, i have created the trigger as USER . Below is what i get when i logon as SYS and do the following commands
select * from dba_objects where object_name in ('DDLTRIGGER','STATS$DDL_LOG');
Code:OWNER OBJECT_NAME SUBOBJECT_NAME OBJECT_ID DATA_OBJECT_ID OBJECT_TYPE CREATED LAST_DDL_TIME TIMESTAMP STATUS TEMPORARY GENERATED SECONDARY SCOTT DDLTRIGGER 30,359.00 TRIGGER 05/20/2009 18:07:36 05/20/2009 18:07:36 2009-05-20:18:07:36 INVALID N N N SCOTT STATS$DDL_LOG 30,347.00 30,347.00 TABLE 05/20/2009 15:39:43 05/20/2009 15:39:43 2009-05-20:15:39:43 VALID N N N




Reply With Quote