Skip to Main Content

Oracle Database Free

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

DOMAIN plus Identity Column

Mike KutzFeb 21 2024 — edited Feb 22 2024

edit much code. jump here for updated concern

I have a feeling that it's mentioned in the docs (I must have skip-read that part)

But, I can't use a domain on an Identity Column (v23.3 FREE VirtualBox)

-- ORA-30675: identity column must be a numeric type
create table test_me (
  id sys.positive_number_d generated always as identity
);

create domain id_d as int
  not null
  check ( value > 0 );

-- ORA-30675: identity column must be a numeric type
create table test_me (
  id id_d generated always as identity
);

-- ORA-00904: "ID_D": invalid identifier
create table test_me (
  id int generated always as identity,
  domain id_d( id )
);
This post has been answered by Chris Saxon-Oracle on Feb 22 2024
Jump to Answer
Comments
Post Details
Added on Feb 21 2024
5 comments
144 views