| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> c.d.o.misc -> truncate problem
I've just tried to do a truncate on a table, but get this error:
ORA-02266: unique/primary keys in table referenced by enabled foreign keys
The table was created like this:
create table headline
(
id number(10) primary key,
headline varchar2(200),
url varchar2(200),
grabtime number(15),
comments varchar2(200),
lang number(4),
constraint fk_headline_lang
foreign key (lang)
references language (id)
);
Is the constraint causing the problem? No row in the headline table has any value in the lang column.
thanks,
![]() |
![]() |