Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: HELP: How to DELETE millions of records (selectively)
Hello Francisco,
What about 'create table as select ...' and then drop, rename and reindex?
HTH, Steve Adams
On Thu, 19 Jun 1997 19:34:01 +0000, Francisco Lameira <francisco.j.lameira_at_telecom.pt> wrote:
>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