CREATE TABLE tab1 (
id NUMBER,
description VARCHAR2(50),
CONSTRAINT tab1_pk PRIMARY KEY (id)
)
ROW ARCHIVAL
Table created.
INSERT /*+ APPEND */ INTO tab1
SELECT level, 'Description of ' || level
FROM dual
CONNECT BY level <= 1000
1000 row(s) inserted.
COMMIT
Statement processed.
SELECT COUNT(*) FROM tab1
| COUNT(*) | 1000 |
|---|
UPDATE tab1
SET ora_archive_state = '1'
WHERE id BETWEEN 751 and 1000
250 row(s) updated.
COMMIT
Statement processed.
SELECT COUNT(*) FROM tab1
| COUNT(*) | 750 |
|---|
ALTER SESSION SET ROW ARCHIVAL VISIBILITY = ALL
Statement processed.
SELECT COUNT(*) FROM tab1
| COUNT(*) | 1000 |
|---|
SELECT ora_archive_state, COUNT(*)
FROM tab1
GROUP BY ora_archive_state
ORDER BY ora_archive_state
| ORA_ARCHIVE_STATE | COUNT(*) | 0 | 750 | 1 | 250 |
|---|
ALTER SESSION SET ROW ARCHIVAL VISIBILITY = ACTIVE
Statement processed.
SELECT COUNT(*) FROM tab1
| COUNT(*) | 750 |
|---|