The fastest way would be
CREATE TABLE <new_tab> AS SELECT * FROM <orig_table where ..> UNRECOVERABLE ;
rename <new_tab> to <orig_table>
add all the indexes and constraints.
Note, if you have lot of dependencies, it may be more complex than described above.
Prince.
"TC" <donotuse_at_donotuse.com> wrote in message news:<hvdpa.568277$L1.166589_at_sccrnsc02>...
> I would drop the indexes, delete the records and recreate the indexes
>
> //tc
>
> "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
> >
> >
