HELP: How to DELETE millions of records (selectively)

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?

Thankx in advance. Received on Thu Jun 19 1997 - 00:00:00 CDT