Dropped some of SYSTEM's objects
Hi, one junior DBA dropped by mistake some of SYSTEM's objects. He generated a DROP.... script, and ran it thinking he was connected as some other user. When he realized he was dropping the wrong objects, he canceled the execution. Here´s a list of what the script did:
select decode(object_type,'TABLE','drop '||object_type||' "'||object_name||'" cascade constraints;','drop '||object_type||' "'||object_name||'";')
from user_objects where object_type in ('TABLE','SEQUENCE','PACKAGE','PROCEDURE','FUNCTION','VIEW','SYNONYM','MATERIALIZED VIEW')
order by object_Type, object_name
/
drop FUNCTION "LOGMNR$COL_GG_TABF_PUBLIC";