On Thu, 15 Mar 2001, Paul Drake wrote: > How's this for starting down the path to the dark side? > select 'spool bdbafh_gets_revenge.lst' from dual <snip> I prefer: spool later.sql select 'drop user '|| username || ' cascade;' from dba_users where username not in ('SYS','SYSTEM','GCONRON'); spool off @later Short, simple, and efficient. :) Cheers, GC -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gregory Conron INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
- RE: Oracle DBA evolution path - please share y... Webber Valerie H
- RE: Oracle DBA evolution path - please share y... lerobe - Lee Robertson
- RE: Oracle DBA evolution path - please share y... Sam P. Roberts (ZADCO ITIS)
- FW: Oracle DBA evolution path - please share y... O'Neill, Sean
- Re: Oracle DBA evolution path - please share y... Don Jerman
- RE: Oracle DBA evolution path - please share y... andrey
- RE: Oracle DBA evolution path - please share y... andrey
- RE: Oracle DBA evolution path - please share y... Gogala, Mladen
- Re: Oracle DBA evolution path - please share y... Paul Drake
- Re: Oracle DBA evolution path - please share y... Paul Drake
- Re: Oracle DBA evolution path - please share y... Gregory Conron
- Re: Oracle DBA evolution path - please share y... Rachel Carmichael
- Re: Oracle DBA evolution path - please share y... Rachel Carmichael
- Re: Oracle DBA evolution path - please share y... Thater, William
- RE: Oracle DBA evolution path - please share y... Jacques Kilchoer
- Re:RE: Oracle DBA evolution path - please shar... dgoulet
- RE: Oracle DBA evolution path - please share y... William Beilstein
- RE: Oracle DBA evolution path - please share y... Boivin, Patrice J
- RE: Oracle DBA evolution path - please share y... Jack C. Applewhite
- RE: RE: Oracle DBA evolution path - please sha... Jacques Kilchoer
- RE: Oracle DBA evolution path - please share y... Hutchins, Robert