Re: "Delete From <table>" taking all day
From: David P <davidp3_at_soho.ios.com>
Date: 1996/08/24
Message-ID: <321f6564.5549622_at_198.4.75.200>#1/1
Date: 1996/08/24
Message-ID: <321f6564.5549622_at_198.4.75.200>#1/1
On 20 Aug 1996 12:41:13 GMT, meskillw_at_ncr.disa.mil (Bill Meskill)
wrote:
If you use ORACLE7 and above, use TRUNCATE
>Hi,
>I have a 4000 row table that's taking quite a long
>time to delete. What's going on?
>
>Bill Meskill
>
>FYI. I have my data and indexes separated on lots of
>different disks and have allocated 80M for the
>SGA (a full database export is 10M). There are only
>2 people on the server.
>
"The opinions expressed here are my own, and are not necessarily that of Oracle Corporation or my employer" Received on Sat Aug 24 1996 - 00:00:00 CEST