purging old data

From: Anurag Minocha <anurag_at_synergy-infotech.com>
Date: Tue, 07 Sep 1999 09:50:06 +0530
Message-ID: <37D49275.2F978DB4@synergy-infotech.com>

Hi,
I want to purge my older data into an ascii file and then delete the data from the tables.
can somebody suggest the best way to do this.

One way i have come up with is the UTL_FILE utility and then truncate the data from the tables,but truncate seems to have some problems. It straight away fails if there is a foreign key. Is there any way i can use the delete command and still reclaim the used space .This is because i will be deleting thousands of records every month and if i use the delete command oracle will still read till the high water mark.

Any help will be greatly appreciated

Thanks in Advance
Anurag

also reply at
anurag_at_synergy-infotech.com Received on Mon Sep 06 1999 - 23:20:06 CDT