Re: Remove everything from a schema

Michel Cadot escribió:
> I use the following script to drop all my objects:
>
> set heading off
> set pagesize 0
> set feedback off
> set timing off
> set time off
> set trimspool on
> set trimout on
> set linesize 100
> set echo off
> spool t
> select 'drop '||object_type||' '||object_name||
> decode(object_type,'CLUSTER',' including tables cascade constraints',
> 'OPERATOR', ' force',
> 'TABLE',' cascade constraints',
> 'TYPE', ' force',
> 'VIEW',' cascade constraints',
> '')||';'
> from user_objects
> where object_type in ('CLUSTER', 'CONTEXT', 'DATABASE LINK', 'DIMENSION',
> 'DIRECTORY', 'FUNCTION', 'INDEX TYPE', 'JAVA',
> 'LIBRARY', 'MATERIALIZED VIEW', 'OPERATOR',
> 'OUTLINE', 'PACKAGE', 'PROCEDURE', 'SEQUENCE',
> 'SYNONYM', 'TABLE', 'TYPE', 'VIEW')
> order by object_type, object_name
> /
> spool off
> @t.lst
> purge recyclebin;

This is not a complement to Charles' solution but an alternative, isn't it? (Running "DROP USER schema CASCADE" would be an option but it implies contacting the DBA.)

The production box will be using a bare Instant Client so I prefer not to rely on SQL*Plus commands but I get the idea. I've run the commands generated by your SELECT query and everything is happily gone. I can easily stuff it in a PHP script (or just run it manually).

Thank you!

-- 
-- http://alvaro.es - Álvaro G. Vicario - Burgos, Spain
-- Mi sitio sobre programación web: http://bits.demogracia.com
-- Mi web de humor al baño María: http://www.demogracia.com
--