Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> truncate problem

truncate problem

From: kev <kevin.porter_at_fast.no>
Date: Wed, 27 Oct 1999 12:39:37 +0100
Message-ID: <3816E479.D88E3A79@fast.no>


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,

Received on Wed Oct 27 1999 - 06:39:37 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US