Create the index separately. ----------------- Ron Reidy Lead DBA Array BioPharma, Inc. -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of dba1 mcc Sent: Thursday, January 20, 2005 2:52 PM To: oracle-l@xxxxxxxxxxxxx Subject: [Q] create foreign key problem??? 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. =09 =09 __________________________________=20 Do you Yahoo!?=20 Yahoo! Mail - You care about security. So do we.=20 http://promotions.yahoo.com/new_mail -- //www.freelists.org/webpage/oracle-l This electronic message transmission is a PRIVATE communication which = contains information which may be confidential or privileged. The information is = intended=20 to be for the use of the individual or entity named above. If you are = not the=20 intended recipient, please be aware that any disclosure, copying, = distribution=20 or use of the contents of this information is prohibited. Please notify = the sender of the delivery error by replying to this message, or notify us = by telephone (877-633-2436, ext. 0), and then delete it from your system. -- //www.freelists.org/webpage/oracle-l