Archiving

Posted by Laurel on
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Archiving-tp2852.html

Hi Erman!
When you have vacation ? :)  Hope you have :)

Do you ha ve experience with Informatica / former Application ?
We doing purge every year using build in utilities. Howether we end-up created clone/archive instance .
So in the long run we will have couple of those... and users dont like it :) as sometimes they need still to run some reports and do that from multiple ones.
Would be much better  if  would be 1  arcive and incremental load ... Too much to ask from oracle, so i am looking at informatica...

Partitioning is another option that is separate pay and there need to do  full investigation how partition .. As affraid design of queries should support it and if we will meet perf issues -> oracle will not support us..
Have you investigated it that ?  Do you have a list of tables and partitioning keys :) ?
I have partitioned cst tables, some queries better , some not.. So I guess I will still purge :)

How are your customers do that ?
Would appreciate your opinion :)
Thanks,Laurel