[ Attachment(s) from David Hicken included below]
After creating a table that has foreign keys, triggers, primary keys, unique
keys, etc., when I click on the script tab in Schema Browser, the SQL command
for creating PK will not run.
for instance:
<>
PROMPT Non-FOREIGN KEY CONSTRAINTS ON TABLE CARD_TRAN_INFO;
ALTER TABLE SWITCH.CARD_TRAN_INFO ADD ( CONSTRAINT PK_CARD_TRAN_INFO PRIMARY KEY
(CARD_NUMBER, SITE_CODE, INVOICE_NUMBER, TRAN_DTS, ORIGIN) USING INDEX
SWITCH.PK_CARD_TRAN_INFO)
/
ALTER TABLE SWITCH.CARD_TRAN_INFO ADD ( CONSTRAINT PK_CARD_TRAN_INFO PRIMARY KEY
(CARD_NUMBER, SITE_CODE, INVOICE_NUMBER, TRAN_DTS, ORIGIN) USING INDEX
SWITCH.PK_CARD_TRAN_INFO)
Error at line 2
ORA-00907: missing right parenthesis
Doesn’t matter if I user F9 or F5.
Checked if it just complex keys or simple keys make a difference and that
doesn’t seem to matter.
This is what my parameter screen looks like (attached).
David Hicken
utahtoad at gmail dot org
Attachment(s) from David Hicken
1 of 1 Photo(s)
screen1.JPG