[Q] create foreign key problem???

From: dba1 mcc <mccdba1_at_yahoo.com>
Date: Thu, 20 Jan 2005 13:51:32 -0800 (PST)
Message-ID: <20050120215132.60790.qmail@web60805.mail.yahoo.com>

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

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Jan 20 2005 - 16:54:37 CST