set head off
set feed off
set pages 0

spool drop_data_access_objs.sql

select 'DROP SYNONYM '||owner||'."'||object_name||'";'
from dba_objects
where owner in ('AMARCHIVE','AMQUERY')
and object_type = 'SYNONYM';

select 'DROP VIEW '||owner||'."'||object_name||'";'
from dba_objects
where owner in ('AMARCHIVE','AMQUERY')
and object_type = 'VIEW';

select 'DROP PACKAGE '||owner||'."'||object_name||'";'
from dba_objects
where owner in ('AMARCHIVE','AMQUERY')
and object_type = 'PACKAGE';

spool off

PROMPT "Dropping objects, this will take a while ..."

@drop_data_access_objs.sql

PROMPT "Dropping Users Cascade, not much longer ..."

drop user AMARCHIVE cascade;

drop user AMQUERY cascade;

PROMPT "Data Access Schemas have been Dropped Successfully"