I'm trying to create an Object table where Domains are used for constraining some of the persisted data.
-- setup
create type test_me_t as object (id int);
/
create domain id_d as int
not null check (value > 5);
-- this throws: ORA-02330: data type specification not allowed
create table test_me of test_me_t (
id domain id_d
);
-- this works
create table test_me of test_me_t;
alter table test_me modify (id domain id_d);
-- clean up
drop table test_me purge;
drop domain id_d;
drop type test_me_t;