-- Oracle 12c: Oracle Table created with ROW ARCHIVAL feature CREATE TABLE lu_transactions (trans_id NUMBER, trans_date DATE, trans_value NUMBER ) ROW ARCHIVAL ; INSERT INTO lu_transactions (trans_id, trans_date, trans_value ) SELECT level*10, SYSDATE+level-1, ROUND(100000*DBMS_RANDOM.value) FROM DUAL CONNECT BY level < 6; COMMIT; SELECT * FROM lu_transactions; UPDATE lu_transactions SET ora_archive_state = 1 WHERE trans_id < 40; COMMIT; SELECT * FROM lu_transactions; ALTER SESSION SET ROW ARCHIVAL VISIBILITY = ALL / SELECT * FROM lu_transactions;
9870