Re: HELP: How to DELETE millions of records (selectively)

steveadams_at_acslink.net.au (Steve Adams) wrote:

>What about 'create table as select ...' and then drop, rename and
>reindex?

This is what I have done recently. The only thing to note is with the latest version of Oracle you can do

   create table ...

        UNRECOVERABLE
        as select ....

This way, no redo entries are generated. Of course you will want a hot-backup right after you recreate the table.

>>Hi,
>>
>>I'm using Oracle 7.1.6 on a Alpha (1 processor, 40 disks of 4.3 GB).
>>
>>I have some BIG problems, so I would like to know the following:
>>
>>- What's the fastest way of selectively delete 2 million records from a
>>table containing 10 million records?
>>
>>- I know we can't disable Rollback but is there anything like that?

• Doug Anderson Oracle Database Administrator DAtheDBA_at_mindspring.com