alter table PER_DATA.person_car_dtl
add constraint FK_pers_car_chk foreign key (p_num,p_dt)
references with no check option
To create references to existing tables, a REFERENCES privilege is needed.
use one of the following:
GRANT REFERENCES ON person_mst TO xyz; /* On all columns */
GRANT REFERENCES (p_num,p_dt) ON person_mst TO xyz; /*On P_NUM,P_DT Only */
GRANT REFERENCES (ALL BUT p_num) ON person_mst TO xyz; /* On all but P_NUM */
Hope this will work for you!