Skip to Main Content

Oracle Database Free

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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
266 views