Hello everybody.
I installed oracle 12C on windows 7.
Then creaete new user:
CREATE USER C##OTO_USER
IDENTIFIED BY oto_user_pass;
GRANT ALL PRIVILEGES TO C##OTO_USER;
Then create new connection with C##OTO_USER
In this connection, I create table:
create table autos (
id integer generated by default on null as IDENTITY unique,
owner_name nvarchar2(50)
);
table created, now trying inserting data into table:
insert into autos
(owner_name)
VALUES
('Nick');
oracle returns error: ORA-30667: cannot drop NOT NULL constraint on a DEFAULT ON NULL column
If trying same, when connect as "sys" user, this error not happens, all works fine, this happens only, when connected with C##OTO_USER user.
Cann you tell me please what may causes this error? that code for creating user, may not creates complete user?
This error happens in both: in SQL Developer and In SQL*Plus also.
Thanks and sorry for my bad english.