Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
ODI SNP tables data getting purged

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
-
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.
0 -
Check configuration document for the snapshot dates and frequency setups.
0 -
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.
0