This content has been marked as final. Show 3 replies
Removing the personalization is not expected to touch product tables at-all. I can think of few possibilities.
+ You may have executed some scripts along with the personalization task which could be causing this
+ Possibly the data in this table is restricted some newly created VPD and hence it is not showing up now.
If you are sure that the data is removed from the database itself, please work with your DBA to use the flashback query to identify how exactly the records were removed. You need to do this ASAP so that you dont loose the history.
Thanks a ton Shivaraj. yes, we have lost all the data so far. Trying to work with DBA on this to recover so far;
Do you think any root cause of this problem. I still couldn't believe what has happened.
Edited by: 883172 on May 28, 2012 3:57 AM
I can't think of any situation in which removing the personalization will wipe out your data.