Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Cleaning WB Objects

SweAnderlineOct 23 2008 — edited Mar 24 2009

Hi!

In our production enviorment we have a couple of batch jobs that go every night, in every job there is about 70 mappings, that means 70 * 15 jobs = 1050 inserts into WB_RT_AUDIT table, after couple of months that table can get pretty big, same with other log tables.

And now I am wondering if any if you guys know any way to somehow cleanse some log tables, I know I can go thrue toad and just truncate the table but Im pretty sure theres alot of other tables that log pretty unnecessery things that have expired.

Any ideas to just keep a enviroment clean for expired and unnecessery data? Im open to suggestions.

This post has been answered by 292515 on Oct 23 2008

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 21 2009

Added on Oct 23 2008

#audit, #data, #data-warehousing, #owb, #problem, #warehouse-builder

12 comments

2,878 views