[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
idx_space
I got "ORA-01735: invalid ALTER TABLE option" on
"using index tablespace idx_space". How to use "using
index space" with foreign key?
Thanks.
__________________________________
Do you Yahoo!?
Yahoo! Mail - You care about security. So do we.
http://promotions.yahoo.com/new_mail
--
//www.freelists.org/webpage/oracle-l
Other related posts:
- » [Q] create foreign key problem???
