Re: Deletion of records
From: Ahmad <mabsoot_at_dubaicourts.gov.ae>
Date: Sun, 27 Apr 2003 14:03:19 +0400
Message-ID: <b8g9vk$50o4_at_news-dxb.emirates.net.ae>
Date: Sun, 27 Apr 2003 14:03:19 +0400
Message-ID: <b8g9vk$50o4_at_news-dxb.emirates.net.ae>
Hello,
Try to use truncate. However be aware that truncate is a ddl statment, so you won't be able to do rollback and beside truncate won't validate the foreign key constarints
Regards,
Ahmad
"priya" <priya_at_informatic.com> wrote in message
news:b836ia$de05_at_news.emirates.net.ae...
> 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 Sun Apr 27 2003 - 12:03:19 CEST