Oracle Database Express Edition (XE)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

creating table with sql statement

565548Apr 10 2007 — edited Apr 11 2007

I am using the following SQL statement to create a table and upload data using atxt file.
CREATE TABLE family (
person_id NUMBER (4) CONSTRAINT person_pk PRIMARY KEY,
Fname VARCHAR2 (20) NOT NULL,
Mname VARCHAR2 (20) NOT NULL,
surname VARCHAR2 (20) NOT NULL,
sex VARCHAR2(1) NOT NULL,
dob DATE NOT NULL,
death_date DATE,
father_id VARCHAR (4) CONSTRAINT bperson_fk REFERENCES family(person_id),
mother_id VARCHAR (4) CONSTRAINT aperson_fk REFERENCES family(person_id));

Once the data loaded this error message shows for each failed row:
ORA-02291: integrity constraint (USER1.BPERSON_FK) violated - parent key not found??
I cannot figure out the problem
Help welcome

Locked Post

New comments cannot be posted to this locked post.

Locked on May 9 2007

Added on Apr 10 2007

5 comments

174 views