Purge the Data with dependencies

From: Sanjay Mishra <smishra_97_at_yahoo.com>
Date: Mon, 20 Aug 2007 09:50:11 -0700 (PDT)
Message-ID: <4400.97158.qm@web51304.mail.re2.yahoo.com>

I want some opinion on Purging solution. I had an application which contains lots of table dependent on Foreign key relation. We had a application that can be used to purge the data as an when required which is basically copying the data into the Temp table(s) and then delete the data from all other depending object. This is good as long as we are specifying some not very high number of records. If the table is very big like close to terabyte, it is not possible due to slow performance of the above process.

Partioning is also not possible due to lots of dependencies and don't carry partitioning license

Cannot make the DB in nologging as it is forced on DB level due to Standby server as well as some stream setup

This is 10g Database and so any good option for Purging/Archiving that can save lots of CPU cycles

TIA
Sanjay

Sick sense of humor? Visit Yahoo! TV's Comedy with an Edge to see what's on, when.
--

http://www.freelists.org/webpage/oracle-l Received on Mon Aug 20 2007 - 11:50:11 CDT