Differences

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

--- indatabasearchiving [2015/07/22 10:41] – z0hpvk
+++ indatabasearchiving [2025/03/08 22:24] (current) – external edit 127.0.0.1
@@ Line 8: / Line 8: @@
 ALTER TABLE employees ROW ARCHIVAL;</code>
-==== Disabling ====
-<code>ALTER TABLE employees NO ROW ARCHIVAL;</code>
 This will create a hidden column called ORA_ARCHIVE_STATE.\\
 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 ====
+<code>ALTER TABLE employees NO ROW ARCHIVAL;</code>
+==== Displaying Archived Rows ====
+<code>-- Make archived rows visible.
+ALTER SESSION SET ROW ARCHIVAL VISIBILITY = ALL;
+-- Make archived rows invisible again.
+ALTER SESSION SET ROW ARCHIVAL VISIBILITY = ACTIVE;</code>