Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations cowski on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL statement

Status
Not open for further replies.

coince

Computer
Joined
Apr 10, 2007
Messages
1
Location
GB
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top