Generate table script doesn't generate "row archival" if activated

El

Member²
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
 
Back
Top