Re: Deletion of Records

From: Ron Reidy <rereidy_at_indra.com>
Date: Tue, 22 Apr 2003 05:09:17 -0600
Message-ID: <3EA522DD.80406@indra.com>

Copy the rows you want to keep to a temp table.
Truncate the perm table.
Copy the rows from temp back to perm
Drop temp.

priya wrote:
> I have a table under Oracle 9i with 20 million records. I have one primary
> and 4 secondary indexes. If i try to delete certain records (80%) of the
> records. It takes
> days to delete. How to do it fast.
>
> Your help in this regard is appreciated.
>
> Thanks
>
>
>
>
Received on Tue Apr 22 2003 - 06:09:17 CDT