We have Auditing area "audit_area" and auditing index area "audit_index" like
d "Audit_area":9,32;8 ......d1 f 204800
d "Audit_area":9,32;8 ......d2
d "Audit_index":10,32;8 ......d1 f 204800
d "Audit_index":10,32;8 ......d2
Currently data is going in d2 extent of both above areas.
If we enable auditarchive using - proutil prod-db -C auditarchive "date value = yesterday" then what happens
1. High Water Mark value maintained by DB will be same?? or less ??
2. After archiver new data will go in auditarea d1 or d2 ?
Thanks
Lalit Kumar
A database does not lower the HWM of an area when records are deleted.
A database will write new data into blocks with free space. If those blocks are in extent d1 or d2 or d3, the db doesn't care.