ODI SNP tables data getting purged — Oracle Analytics

Oracle Business Intelligence Applications

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

ODI SNP tables data getting purged

Received Response
12
Views
3
Comments

Hi,

ODI SNPtables are getting purged automatically .

In BI Apps implementation ODI tables are getting purged automatically . Data is there for only 7 days.

Is there any setting which does this ??

Any pointers regarding this would be helpful

Regards,

Mahesh

Answers

  • Anjum Ara
    Anjum Ara Rank 4 - Community Specialist

    Hi Mahesh

    You can check with your system team or ODI team if they have setup automation process to purge the tables not quite possible that it does it on its own.

  • Thomas Dodds
    Thomas Dodds Rank 8 - Analytics Strategist

    Check configuration document for the snapshot dates and frequency setups.

  • 841717
    841717 Rank 2 - Community Beginner

    I think what you're trying to say is that operator logs (stored in some SNP tables) are getting purged every 7 days. Correct me if I'm wrong.

    To retain logs for a longer time, open the generated (or predefined) load plan and set "Keep Log History (Days)" to a higher number. Note that since you're retaining logs for a longer time, your SNP log table will grow to a great extent (as each LP execution produces a ton of log). So make sure the number is high enough to fulfill your needs but not very large so that it does not become a storage overhead.