Purge the Data with dependencies
- From: Sanjay Mishra <smishra_97@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Mon, 20 Aug 2007 09:50:11 -0700 (PDT)
Hi
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.
Other related posts:
