Indexes are only automatically created to enforce primary key and unique
constraints.
If you want an index to match the columns of a foreign key constraint, you
will have to do it separately.
P.S. If you already have a non-unique index on the PK or unique constraint
column(s), then Oracle will use that one to enforce the PK or unique
constraint.
> -----Original Message-----
> From: DENNIS WILLIAMS [mailto:DWILLIAMS_at_LIFETOUCH.COM]
>
> I'm trying to add a foreign key constraint to a table, and specify the
> tablespace and pctfree. Here is the syntax I'm using:
>
> alter table jobproductoutrigger add (
> constraint fk_jobprodu_currjobfa_currjobf foreign key (
> jobnbr, sourcefiscalyear )
> references currjobfact (jobnbr, sourcefiscalyear)
> using index tablespace index73
> pctfree 5)
> /
>
> This produced the error:
>
> ERROR at line 5:
> ORA-00907: missing right parenthesis
>
> Can someone spot what I'm missing? This is Oracle 8.1.6.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jacques Kilchoer
INET: Jacques.Kilchoer_at_quest.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Wed Mar 26 2003 - 14:39:01 CST
