[Chicago-talk] Help on Purging Database
Steve Peters
steve at fisharerojo.org
Tue Jan 24 12:48:22 PST 2006
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
More information about the Chicago-talk
mailing list