Kayshav.com
About Developer Oracle 12c Oracle 19c Technology Information Sitemap

Oracle Table ROW ARCHIVAL feature
-- 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;



Oracle 12c Table Design New Features

Oracle 12c Index

Oracle registered trademark of Oracle Corporation.

Last Revised On: February 28th, 2017

  11062