Re: Purge the Data with dependencies

  • From: "Dennis Williams" <oracledba.williams@xxxxxxxxx>
  • To: smishra_97@xxxxxxxxx
  • Date: Mon, 20 Aug 2007 13:00:57 -0500

Sanjay,

A terabyte of business-critical data and they won't spring for the
partitioning option? Something is seriously wrong here. Maybe you can use
this issue to justify the purchase.
    Your best option may be to write a program that purges the data a few
rows at a time and commits every few rows. Just let it run for months as
needed.

Dennis Williams

Other related posts: