Re: Deletion of records

gspk_at_yahoo.com (Prince Kumar) wrote in message news:<629275ba.0304221634.77c52fc3_at_posting.google.com>...
> 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
> > >
> > >
> > >
> > >

unrecoverable command simply ignores redo right? or does it ignore archivelog mode? Received on Mon Apr 28 2003 - 13:19:53 CEST