Re: Fun things with Truncate

From: Sybrand Bakker <postmaster_at_sybrandb.demon.nl>
Date: Wed, 18 Aug 1999 20:25:24 +0200
Message-ID: <935000746.25228.0.pluto.d4ee154e@news.demon.nl>

Probably this has been resolved in 8i :)

Best regards,

Sybrand Bakker, Oracle DBA

Connor McDonald <connor_mcdonald_at_yahoo.com> wrote in message news:37BA8D8E.D71_at_yahoo.com...
> Try this on 8.0.5...
>
>
> a. create a table with lots of extents so that truncate will take a few
> seconds to run
>
> b. 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 - 13:25:24 CDT