REM
REM DBAToolZ NOTE:
REM	This script was obtained from DBAToolZ.com
REM	It's configured to work with SQL Directory (SQLDIR).
REM	SQLDIR is a utility that allows easy organization and
REM	execution of SQL*Plus scripts using user-friendly menu.
REM	Visit DBAToolZ.com for more details and free SQL scripts.
REM
REM 
REM File:
REM 	c_user_obj_today_drop.sql
REM
REM <SQLDIR_GRP>MAINT USER SEGMENT</SQLDIR_GRP>
REM 
REM Author:
REM 	Vitaliy Mogilevskiy (www.dbatoolz.com)
REM 
REM Purpose:
REM	<SQLDIR_TXT>
REM	DROPS objects by user prompts for LIKE clause
REM	use this for cleanups :-)
REM	spools into a DDL file with DROP stmts ...
REM	will not run the DDL file
REM	</SQLDIR_TXT>
REM
REM Usage:
REM	c_user_obj_today_drop.sql
REM 
REM Example:
REM	c_user_obj_today_drop.sql
REM
REM
REM History:
REM	07-25-2001	VMOGILEV	Created
REM
REM


@x_db_name.sql

set lines 300
set trims on
set pages 0
set feedback off
set verify off

col ln format a300

spool c_user_obj_today_drop.&db_name..&&obj_like..run
prompt set feedback on

select 'PROMPT Dropping '||object_type||'.'||owner||'.'||object_name||' created on '||TO_CHAR(created,'DD-MON-RRRR HH24:MI:SS') ln
,      'DROP '||object_type||' '||owner||'.'||object_name||';' ln
from dba_objects
where object_name like '&&obj_like'
and object_type != 'PACKAGE BODY'


/
spool off


ed c_user_obj_today_drop.&db_name..&&obj_like..run

undefine obj_like