Re: Quick (?) UNIX Question
- From: Mladen Gogala <mladen@xxxxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Fri, 16 Apr 2004 15:44:12 -0400
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@xxxxxxxxxxx>
> skrev: > HUH??? THAT WAS A JOKE??
> >
> > -----Original Message-----
> > From: Carmen Rusu
> > [mailto:carmen.rusu@xxxxxxxxxxxxxxx]
> > Sent: Friday, April 16, 2004 10:02 AM
> > To: oracle-l@xxxxxxxxxxxxx
> > Subject: Re: Quick (?) UNIX Question
> >
> >
> > ..along with everything else in the / directory
> > ...dont do it! another Mladen-esque joke!
> >
> >
> > Carmen Rusu
> > DBA
> >
> > >>> mladen@xxxxxxxxxxxxxxx 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@xxxxxxxxxxxxx=20
> > put 'unsubscribe' in the subject line.
> > --
> > Archives are at
> > //www.freelists.org/archives/oracle-l/=20
> > FAQ is at
> >
> //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@xxxxxxxxxxxxx
> > put 'unsubscribe' in the subject line.
> > --
> > Archives are at
> > //www.freelists.org/archives/oracle-l/
> > FAQ is at
> > //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@xxxxxxxxxxxxx
> > put 'unsubscribe' in the subject line.
> > --
> > Archives are at
> > //www.freelists.org/archives/oracle-l/
> > FAQ is at
> > //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@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at //www.freelists.org/archives/oracle-l/
> FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
