DB Wiki

User Tools

Site Tools

Trace:
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:41] – z0hpvkindatabasearchiving [2025/03/08 22:24] (current) – external edit 127.0.0.1
Line 8: Line 8:
  
 ALTER TABLE employees ROW ARCHIVAL;</code> 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.\\ 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 ==== 
 +<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>
indatabasearchiving.1437561662.txt.gz · Last modified: 2025/03/08 22:23 (external edit)