[Chicago-talk] Help on Purging Database

[Steve Peters]

On Tue, Jan 24, 2006 at 12:39:08PM -0800, tiger peng wrote:
> Hello All,
> 
> There is a need to create a general tool for purging
> old records from transaction databases (Oracle). The
> referential integrity is required but foreign keys or
> triggers are no allowed (for performance reason).
> 
> I did googling and cpanning without good solution. Is
> there anyone did similar tasks or knows where are the
> similar utilities?
> 

Without knowing any requirements or anything else about your system, 
your likely best bet will be something custom in PL/SQL.  I would highly 
doubt if a generic tool is available that does not at least rely on 
foreign keys.

Steve Peters
steve at fisharerojo.org