Oracle Business Intelligence Applications Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› More Solutions› Oracle Business Intelligence Applications Forum

Categories

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

ODI SNP tables data getting purged

Received Response
21
Views
3
Comments
MaheshB
MaheshB Rank 1 - Community Starter
in Oracle Business Intelligence Applications Forum

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 & AI 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.