"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 Wed Mar 23 2005 - 19:53:05 CST
