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 -> Fun things with Truncate

Fun things with Truncate

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Wed, 18 Aug 1999 18:40:14 +0800
Message-ID: <37BA8D8E.D71@yahoo.com>


Try this on 8.0.5...

  1. create a table with lots of extents so that truncate will take a few seconds to run
  2. run truncate and hit Ctrl-C to cancel it before it finishes...

Ooop! The database has crashed !

Ah well..
--



Connor McDonald
"These views mine, no-one elses etc etc"
connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue."
Received on Wed Aug 18 1999 - 05:40:14 CDT

Original text of this message

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