| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: purging old data
Anurag Minocha wrote:
>
> 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
disabling the constraint will allow the truncate (and then re-enable it)...
note that hwm and space reclaim are separate items. if you delete the rows, you CAN re-use the space (ie the table can), but yes, the HWM will not be reset.
--
"Some days you're the pigeon, and some days you're the statue." Received on Tue Sep 07 1999 - 05:52:03 CDT
 |
 |