User Tools

Site Tools


indatabasearchiving

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
indatabasearchiving [2015/07/22 10:43] z0hpvkindatabasearchiving [2025/03/08 22:24] (current) – external edit 127.0.0.1
Line 11: Line 11:
 This will create a hidden column called ORA_ARCHIVE_STATE.\\ This will create a hidden column called ORA_ARCHIVE_STATE.\\
 By default this column will have a value of 0 for each row.\\ By default this column will have a value of 0 for each row.\\
-You can now use update statements to alter the value of this column.\\+Any value greater than zero makes a SELECT statement ignore this row when ROW ARCHIVAL VISIBILITY is set to ACTIVE.\\
  
 ==== Disabling ==== ==== Disabling ====
indatabasearchiving.1437561797.txt.gz · Last modified: 2025/03/08 22:23 (external edit)