I can create a column with a default enum value. But, the default value isn't valid during insert.
Example code:
create domain status_d as enum ( initializing, analyzing, curating, finalized, deprecated );
create table test_col (
id int generated always as identity
,my_status status_d default on null hr.status_d.initializing -- adjust schema as needed
,some_data varchar2(50)
);
-- these fail with ORA-00984: column not allowed here
insert into test_col ( some_data ) values
('abc');
insert into test_col ( some_data, my_status ) values
('abc', default);
-- this works
insert into test_col ( some_data, my_status ) values
('abc', status_d.initializing);
-- but, this fails
insert into test_col ( some_data, my_status ) values
('abc', status_d.initializing),
('def', status_d.initializing);
DB: 23.4 VirtualBox