Possible reasons :
o Trigger on delete
o cascading foreign keys
o frantic rollback segment extension
o ...
I'd rather use TRUNCATE TABLE if all the rows must go.
--
Regards,
Stephane Faroult
email: sfaroult_at_oriolecorp.com
Oriole Corporation
Voice: +44 (0) 7050-696-269
Fax: +44 (0) 7050-696-449
Performance Tools & Free Scripts
------------------------------------------------------------------
http://www.oriolecorp.com, designed by Oracle DBAs for Oracle DBAs
------------------------------------------------------------------
>
> Any idea why a delete of all the rows in a table might take hours when there are only 30,000 rows? There are no other users on the system. Rowlength is about 120.
>
> Dave Turner
Received on Mon Jun 26 2000 - 09:36:03 CDT
