Example:
CREATE TABLE test_row_archival (
COLUMN1 VARCHAR2(1),
COLUMN2 VARCHAR2(1))
ROW ARCHIVAL;
When we go to "view sql" of that table doesn't include ROW ARCHIVAL:
create table TEST_ROW_ARCHIVAL
(
column1 VARCHAR2(1),
column2 VARCHAR2(1)
)
tablespace DATAXXX
pctfree 10
initrans 1
maxtrans 255;
For check if ROW ARCHIVAL is enabled or not: SELECT 1 FROM USER_TAB_COLS WHERE TABLE_NAME = 'TEST_ROW_ARCHIVAL' AND COLUMN_NAME = 'ORA_ARCHIVE_STATE';
Thanks
CREATE TABLE test_row_archival (
COLUMN1 VARCHAR2(1),
COLUMN2 VARCHAR2(1))
ROW ARCHIVAL;
When we go to "view sql" of that table doesn't include ROW ARCHIVAL:
create table TEST_ROW_ARCHIVAL
(
column1 VARCHAR2(1),
column2 VARCHAR2(1)
)
tablespace DATAXXX
pctfree 10
initrans 1
maxtrans 255;
For check if ROW ARCHIVAL is enabled or not: SELECT 1 FROM USER_TAB_COLS WHERE TABLE_NAME = 'TEST_ROW_ARCHIVAL' AND COLUMN_NAME = 'ORA_ARCHIVE_STATE';
Thanks