Data Archiving - Multiple Archiving object for a table.

Former Member — Wed, 15 Apr 2015 06:59:09 GMT

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

Re: Data Archiving - Multiple Archiving object for a table.

Former Member — Wed, 15 Apr 2015 07:23:13 GMT

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

topic Data Archiving - Multiple Archiving object for a table. in Application Development and Automation Discussions

Data Archiving - Multiple Archiving object for a table.

Re: Data Archiving - Multiple Archiving object for a table.