Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Full table scans

Re: Full table scans

From: Antoine BRUNEL <antoinebrunel_at_yahoo.fr>
Date: Wed, 7 May 2003 00:35:16 +0200
Message-ID: <3eb838a5$0$9027$79c14f64@nan-newsreader-02.noos.net>


what you said is not very funny

NEVER DO "TRUNCATE TABLE" ON SYS OBJECTS !!!! THIS WILL DESTROY YOUR DATABASE AT ONCE "Telemachus" <telemachus_at_ulysseswillreturn.net> a écrit dans le message de news:zsOta.12035$pK2.15833_at_news.indigo.ie...
> Here it is :
>
> sqlplus sys/xxxxx
>
> truncate table sys.tab$;
> truncate table sys.col$;
> truncate table sys.seg$;
> rollback work ; < snigger >
> exit;
>
> if that's not the worst possible sql statement(s) ever
>
>
> <Warning : don't try this at home - joke only >
> "Kalle" <kminerva_at_jippii.fi> wrote in message
> news:3EB79950.8CA5BA2F_at_jippii.fi...
> > Hi all,
> >
> > how I am able to locate the worst possible sql-statements from sga..
> >
> > Merci Beaucoup...
> >
> > Kalle
> >
>
>
Received on Tue May 06 2003 - 17:35:16 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US