Tuesday, December 13, 2011

Script to find out if any new table/procedure added in the schema in past 24 hours


set serveroutput on
declare
v varchar2(2000);
begin
     for i in (select object_name,object_type from dba_objects where to_date(created,'yy-mm-dd') >= to_date(sysdate-1,'yy-mm-dd') and owner = 'USER')
loop

select dbms_metadata.get_ddl(i.object_type,i.object_name,'USER') into v from dual;
dbms_output.put_line(v);
end loop;

end ;

No comments:

Post a Comment