Re: deleting all database objects belonging to a user

Use this PL/SQL script to drop objects from your schema.

set heading off
set lines 132
set pages 0
btitle off
ttitle off
set feedback off
set echo off
set pause off
set verify off

spool drop_objects.sql

Select 'drop '||object_type||' '||object_name||decode(object_type, 'TABLE', ' cascade constraints', null)||';' from user_objects;

spool off

start drop_objects.sql
host rm drop_objects.sql
exit

-- 
/===============================================================\


| Jay Cappy                        Bellsouth Telecommunications |

| Computer Consultant              jcappy_at_secis.com             |


| Project Leader and Oracle SME    205/733-5368                 |


\===============================================================/