Re: Is it possible to delete parts of a table without using rollback??

From: Jim Kennedy <kennedy-downwithspammersfamily_at_attbi.net>
Date: Wed, 23 Mar 2005 17:53:05 -0800
Message-ID: <85ednTdbBJfHgN_fRVn-jw_at_comcast.com>

"Gert Schumann" <gertschumann_at_web.de> wrote in message news:e652ddaa.0503230543.221b6d4b_at_posting.google.com...
> I want to delete just parts of tables, so I can't use 'TRUNCATE'. As I
> want to delete about millions of lines, I need a very big rollback
> segment. The best way would be to delete without using rollback
> because the delete really takes a lot of time copying all data into
> the rollback file. Is this possible with oracle?
> Many thanks for any help!
> Gert
No, that would cause potential data inconsistencies. Jim Received on Thu Mar 24 2005 - 02:53:05 CET

This message: [ Message body ]
Next message: jwarnick: "Streams"
Previous message: Jim Kennedy: "Re: Fast bulk load with API?"
In reply to: Gert Schumann: "Is it possible to delete parts of a table without using rollback??"
In reply to Gert Schumann: "Is it possible to delete parts of a table without using rollback??"
Next in thread: Mark.Powell_at_eds.com: "Re: Is it possible to delete parts of a table without using rollback??"
Reply: Mark.Powell_at_eds.com: "Re: Is it possible to delete parts of a table without using rollback??"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message