Steven Cardinal wrote:
>
> Just installed Oracle8 EE 8.0.4 on NT .  We have a table with about 300,00
> records which we truncate as part of our process.  Since we are just
> evaluating it, we don't have access to Oracle patches (I guess they don't
> make them publicly available?).  Anyway, the truncate (or a drop table) is
> taking about an hour!!  The server has 1.2 Gb RAM (600 Mb SGA), the DATA01
> tablespace in made up of 6 1Gb datafiles (wasn't aware of the 4Gb datafile
> bug until last week - what a drag) on a RAID5 array.
>  Since TRUNCATE is not logged - why is it taking so long?  I'm new to
> Oracle, so I don't even know where to begin to look.  SQLLDR seems to load
> the data in a good amount of time.
>
> Thanks
> Steve

Do you have bucketload of extents ?  If the table has thousands of
extents then Oracle will take a long to clean all this up..

If you have a support contract with Oracle, you can download patches
from www.oracle.com (follow the supports links to Metalink)
--
===========================================
Connor McDonald
"These views mine, no-one elses etc etc"
[email protected]