Create a table with ROW ARCHIVAL enabled

CREATE TABLE employees_indbarch   
 (employee_id NUMBER(6) NOT NULL,   
  first_name VARCHAR2(20), last_name VARCHAR2(25) NOT NULL,   
  email VARCHAR2(25) NOT NULL, phone_number VARCHAR2(20),   
  hire_date DATE NOT NULL, job_id VARCHAR2(10) NOT NULL, salary  NUMBER(8,2),  
  commission_pct NUMBER(2,2), manager_id NUMBER(6), department_id NUMBER(4)) ROW ARCHIVAL

Display the structure of the table

SELECT SUBSTR(COLUMN_NAME,1,22) NAME, SUBSTR(DATA_TYPE,1,20) DATA_TYPE, COLUMN_ID AS COL_ID,  
  SEGMENT_COLUMN_ID AS SEG_COL_ID, INTERNAL_COLUMN_ID AS INT_COL_ID, HIDDEN_COLUMN, CHAR_LENGTH   
  FROM USER_TAB_COLS WHERE TABLE_NAME='EMPLOYEES_INDBARCH'

Insert data into the table

INSERT INTO employees_indbarch(employee_id, first_name, last_name, email,  
  hire_date, job_id, salary, manager_id, department_id)   
  VALUES (251, 'Scott', 'Tiger', 'scott.tiger@example.com', '21-MAY-2009',  
 'IT_PROG', 50000, 103, 60)

INSERT INTO employees_indbarch(employee_id, first_name, last_name, email, 
  hire_date, job_id, salary, manager_id, department_id)  
  VALUES (252, 'Jane', 'Lion', 'jane.lion@example.com', '11-JUN-2009',  
  'IT_PROG', 50000, 103, 60)

INSERT INTO employees_indbarch(employee_id, first_name, last_name, email,   
  hire_date, job_id, salary, manager_id, department_id)   
  VALUES (253, 'Bob', 'Bear', 'bob.bear@example.com', '15-JUL-2009',  
  'IT_PROG', 50000, 103, 60)

SELECT employee_id, ORA_ARCHIVE_STATE FROM employees_indbarch

Set the a record to INACTIVE

UPDATE employees_indbarch SET ORA_ARCHIVE_STATE = '1' WHERE employee_id = 252

SELECT employee_id, ORA_ARCHIVE_STATE FROM employees_indbarch

ALTER SESSION SET ROW ARCHIVAL VISIBILITY=ACTIVE

SELECT employee_id, ORA_ARCHIVE_STATE FROM employees_indbarch WHERE ORA_ARCHIVE_STATE = '0'

ALTER SESSION SET ROW ARCHIVAL VISIBILITY=ALL

SELECT employee_id, ORA_ARCHIVE_STATE FROM employees_indbarch