tag:blogger.com,1999:blog-7075074362027571313.post8913201160142189147..comments2024-03-27T23:23:31.236-07:00Comments on OracleDBPro - Pini Dibask Blog: 12c New feature - Invisible Rows A.K.A In-Database ArchivingPini Dibask, Oracle ACEhttp://www.blogger.com/profile/10471259124884549777noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-7075074362027571313.post-40627169205262297822015-11-24T02:17:52.698-08:002015-11-24T02:17:52.698-08:00Hi Lasse,
Actually not only '1' represent...Hi Lasse,<br /><br />Actually not only '1' represents an archived row. Every string other than '0' represents an archived row (although 1' is the common value to represent an archived row because DBMS_ILM package relies on this constant).<br /><br />I would change the delete statement to be:<br />DELETE FROM test WHERE ora_archival_state <> '0'<br /><br />Thanks for this comment Lasse.Pini Dibask, Oracle ACEhttps://www.blogger.com/profile/10471259124884549777noreply@blogger.comtag:blogger.com,1999:blog-7075074362027571313.post-58325083813901383992015-11-21T17:26:31.797-08:002015-11-21T17:26:31.797-08:00Just one of those things that might come in handy ...Just one of those things that might come in handy one day. <br /><br />Just wanted to mention that if you want to delete the archived rows, just do:<br />SQL> ALTER SESSION SET ROW ARCHIVAL VISIBILITY=ALL;<br />SQL> DELETE FROM test WHERE ora_archival_state='1';<br /><br />Regards LasseL. Jenssenhttps://www.blogger.com/profile/16945919361267764584noreply@blogger.com