Forum Stats

  • 3,741,519 Users
  • 2,248,442 Discussions


History table in SQL (Oracle 19c)

User_3ZQRH Member Posts: 70 Red Ribbon


Hope this query is not irrelevant to this group.

I am building a live table ( and its' corresponding history table which will hold any changes made to the live table) in SQL (Oracle DB - 19 c)

As such the history table is not used by the application (except is rare scenario) for audit purpose/tracing back a data quality issue.

There is unique constraint (business validation) built on the Live table. Do I need to replicate the same constraint on the history table as well ? Is that the practice ? or I should not be creating any constraint on history table because it will only be populated via Live table ( and there is already an constraint implemented on the live table)

Sign In or Register to comment.