CREATE TABLE tab1 ( 
  id          NUMBER, 
  description VARCHAR2(50), 
  CONSTRAINT tab1_pk PRIMARY KEY (id) 
) 
ROW ARCHIVAL

INSERT /*+ APPEND */ INTO tab1 
SELECT level, 'Description of ' || level 
FROM   dual 
CONNECT BY level <= 1000

COMMIT

SELECT COUNT(*) FROM tab1

UPDATE tab1 
SET    ora_archive_state = '1' 
WHERE  id BETWEEN 751 and 1000

COMMIT

SELECT COUNT(*) FROM tab1

ALTER SESSION SET ROW ARCHIVAL VISIBILITY = ALL

SELECT COUNT(*) FROM tab1

SELECT ora_archive_state, COUNT(*) 
FROM   tab1 
GROUP BY ora_archive_state 
ORDER BY ora_archive_state

ALTER SESSION SET ROW ARCHIVAL VISIBILITY = ACTIVE

SELECT COUNT(*) FROM tab1