Is it possible to delete parts of a table without using rollback??
From: Gert Schumann <gertschumann_at_web.de>
Date: 23 Mar 2005 05:43:05 -0800
Message-ID: <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 Received on Wed Mar 23 2005 - 14:43:05 CET
Date: 23 Mar 2005 05:43:05 -0800
Message-ID: <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 Received on Wed Mar 23 2005 - 14:43:05 CET