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.