Ora-30667 cannot reject default zero constraint on zero column

First of all, I appreciate any help and regret my English.

I am a student, and my teacher created a schema for me, so I could work with an Oracle database. It worked fine, but today I deleted some tables and added others, and when I try to insert something into new tables, it gives me an error:

ora-30667 cannot reject default zero constraint on zero column

I read something about this error, and some say that they empty the trash, but that did not work for me; he still gives me this error.

Even a simple example gives me an error:

create table example(example_id number(10), example_name varchar(255));
insert into example(example_id, example_name) values(1, 'example');

Please help me, I have to do this work, but this error does not allow me to do this.

Oracle: Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production

:

, :

create table tipo_funcionario(
id_tipo_funcionario number(10),
descricao varchar(255)
);

insert into tipo_funcionario(id_tipo_funcionario, descricao) values(1, 'gestor');

, , :

insert into tipo_funcionario(id_tipo_funcionario, descricao) values(1, 'gestor')

Error report - 

SQL Error: ORA-00604: error occurred at recursive sql level 1


ORA-30667: cannot drop not null constraint on a default on null column

00604. 00000 -  "error occurred at recursive SQL level %s"

*Cause:    An error occurred while processing a recursive SQL statement
           (a statement applying to internal dictionary tables).

*Action:   If the situation described in the next error on the stack
           can be corrected, do so; otherwise contact Oracle Support.
+4
1

, , : , , SQL Plus, . , . , GUI " SQL", , .

0

Source: https://habr.com/ru/post/1620212/


All Articles