Optimising Journal Line Queries: 5. Conclusion
18 hours ago
Issue:
Recently cloned an environment from PROD & surprised to see PRCSYSPURGE process deleting rows from other environment [PROD].
Solution:
On refreshing one environment (Development) with other database (Production) then that means that in PS_CDM_LIST table the field OUTPUTDIR still contains the database name for Production. Changing this helped to resolve the issue.
The Green Marine template by Ian Main - Converted to Blogger Template by Blogcrowds