[Q] create foreign key problem???

  • From: dba1 mcc <mccdba1@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Thu, 20 Jan 2005 13:51:32 -0800 (PST)

I tried to create foreign ley constraint with index
using following command:

alter table spinfo add constraint fk11 foreign key
(cbnum) references primary_info using index tablespace

I got "ORA-01735: invalid ALTER TABLE option" on
"using index tablespace idx_space".  How to use "using
index space" with foreign key?


Do you Yahoo!? 
Yahoo! Mail - You care about security. So do we. 

Other related posts:

  • » [Q] create foreign key problem???