Data Archiving - Multiple Archiving object for a table.

[Former Member]

Hi,

I am in the initial phase of archiving project. I have targeted top 30 tables and I am able to list all the archiving objects for these tables. But I am facing problem when I have multiple object for a particular table.

Say for eg, DB15 lists 5 archiving objects for a table. I guess, using all the 5 archiving objects does not impact the table in the same way. Some may have little impact. So archiving using all these may not give the desirable space gain. Only one or two among 5 may be useful in terms of time and effort /resource. My doubt is how to find that suitable archiving object. I am assuming that fair idea of business process will help in tracing, but is there any other way to know the top most critical objects?

Thanks,

Abhishek

[Former Member]

Hi Abhishek

Why you need create multiple archiving objects for one table?

WRITE, DELETE, READ on same table using just only one archiving object is not enough to your case?

regards,
Archer