Search notes:

ORA-38397: table is not enabled for the ILM feature

The following statement throws ORA-38397: table is not enabled for the ILM feature:

create table tq84_ora_38397(
   id integer primary key,
   txt varchar2(20)
)
no row archival;

This one runs ok:

create table tq84_ora_38397(
   id integer primary key,
   txt varchar2(20)
)
row archival;

Now, altering to no row archival is possible:

alter table tq84_ora_38397 no row archival;

See also