Re: Quick (?) UNIX Question

Drop user sys cascade will not work, because it would hopelessly deadlock itself. I tried it once, just for fun. Version 10 has "drop database" command. If you are giving me "autodestruct" answers, please make sure that the "destruct" part really work. Now, this is somewhat similar to the scene in which roman centurion corrects the graffiti by Brian Cohen, which reads "Romans, go home". So, let me correct the "autodestruct" advice you're going to give me:

Prerequisites

You must have the SYSDBA system privilege to issue this statement. The database must be mounted in exclusive and restricted mode, and it must be closed.

Syntax

drop_database::=
DROP DATABASE; Some things in life are bad
They can really make you mad
Other things just make you swear and curse. When you're chewing on life's gristle
Don't grumble, give a whistle
And this'll help things turn out for the best...

    And...always look on the bright side of life...     Always look on the light side of life...

Above all, remember that the last laugh is on you.

On 04/16/2004 03:16:34 PM, Jocke Treugut wrote:
> I know someone on this list, whatever question he will
> raise, my answer will be:
>
> DROP USER SYS CASCADE;
> DROP TABLESPACE SYSTEM INCLUDING CONTENTS;
> DROP DATABASE;
>
> and then spit on your boss, get fired, and get a life!
>
>
> --- "Vergara, Michael (TEM)" <mvergara_at_guidant.com>
> skrev: > HUH??? THAT WAS A JOKE??
> >
> > -----Original Message-----
> > From: Carmen Rusu
> > [mailto:carmen.rusu_at_rrc.state.tx.us]
> > Sent: Friday, April 16, 2004 10:02 AM
> > To: oracle-l_at_freelists.org
> > Subject: Re: Quick (?) UNIX Question
> >
> >
> > ..along with everything else in the / directory
> > ...dont do it! another Mladen-esque joke!
> >
> >
> > Carmen Rusu
> > DBA
> >
> > >>> mladen_at_wangtrading.com 4/16/2004 11:36:23 AM >>>
> > Another thing to try would be su - root -c "rm -rf
> > /"=20
> > It would make the file disappear, I can guarantee
> > that.
> >
> >
> > On 04/16/2004 12:30:07 PM, Ravi Kulkarni wrote:
> > > Try this, if you haven't already :
> > >=20
> > > cd to that directory and say rm -i *
> > > when it asks for the file, say yes.
> > --=20
> > Mladen Gogala
> > Oracle DBA
> >
> ----------------------------------------------------------------
> > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.com=20
> >
> ----------------------------------------------------------------
> > To unsubscribe send email to:
> > oracle-l-request_at_freelists.org=20
> > put 'unsubscribe' in the subject line.
> > --
> > Archives are at
> > http://www.freelists.org/archives/oracle-l/=20
> > FAQ is at
> >
> http://www.freelists.org/help/fom-serve/cache/1.html=20
> >
> -----------------------------------------------------------------
> >
> ----------------------------------------------------------------
> > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.com
> >
> ----------------------------------------------------------------
> > To unsubscribe send email to:
> > oracle-l-request_at_freelists.org
> > put 'unsubscribe' in the subject line.
> > --
> > Archives are at
> > http://www.freelists.org/archives/oracle-l/
> > FAQ is at
> > http://www.freelists.org/help/fom-serve/cache/1.html
> >
> -----------------------------------------------------------------
> >
> ----------------------------------------------------------------
> > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.com
> >
> ----------------------------------------------------------------
> > To unsubscribe send email to:
> > oracle-l-request_at_freelists.org
> > put 'unsubscribe' in the subject line.
> > --
> > Archives are at
> > http://www.freelists.org/archives/oracle-l/
> > FAQ is at
> > http://www.freelists.org/help/fom-serve/cache/1.html
> >
> -----------------------------------------------------------------
>
> Höstrusk och grå moln - köp en resa till solen på Yahoo! Resor på adressen http://se.docs.yahoo.com/travel/index.html
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
>

-- 
Mladen Gogala
Oracle DBA
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------