Deleting records having reference column common to sys_audit and sys_audit_relation tables
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-31-2024 09:18 AM
I see there is a reference column “Audit” on sys_audit_relation table referencing to the sys_audit table document_key column. Is there any dependency between these two tables regarding deleting records in either order? In other words if the record in sys_audit_relation is deleted by the custom script first will that cause an issue/error at that time or later when the referenced record in sys_audit is deleted by table cleaner because the sys_audit.document_key column reference to sys_audit_relation.audit is ghosted because it has already be deleted. Likewise vice versa would there be an issue/error if the Table Cleaner deleted the sys_audit record first?
0 REPLIES 0