are all changes tracked in sys_history_line?

[juan9]

are all changes tracked in sys_history_line?
if not, what dictates whether a tables records changes are tracked in sys_history_line or not

[Bert_c1]

No, records in that table are updated when a user accesses the audit history of a record. See:

DiffBtwnAuditHistSets.html

[Shivalika · Accepted solution]

Hello @juan9 

I looked into this and all the records wherever there is any insert or update operation are stored in sys_history_line table it should be a field change. 

Second there is a difference of which changes are not there - then it's about audit table. If the dictionary attribute no_audit = true is added then it's not audited. 

But same is not for history_line and it stores all. 

Kindly mark my answer as helpful and accept solution if it helped you in anyway. This will help me be recognized for the efforts and also move this questions from unsolved to solved bucket. 

Regards,

Shivalika 

My LinkedIn - https://www.linkedin.com/in/shivalika-gupta-540346194

My youtube - https://youtube.com/playlist?list=PLsHuNzTdkE5Cn4PyS7HdV0Vg8JsfdgQlA&si=0WynLcOw

NeEISQCY

[juan9]

this seems correct, let me double check and I will accept the solution:)
thank u for your help!