[program-l] Oracle SQL constraint question

Hi,
The pay_code table in the test region has a constraint on it called PK_COLUMNS. 
 The pay_code table in production has no constraints.  I am trying to set the 
production pay_code table up with the same constraint as the test pay_code 
table.  I came up with the following code, but keep getting errors.  Does 
anyone have any advice? 

The code with the error message follows:

SQL> alter table pay_code add unique (constraint) PK_COLUMNS on pay_code 
(paycode);
alter table pay_code add unique (constraint) PK_COLUMNS on pay_code (paycode)
                                             *
ERROR at line 1:
ORA-01735: invalid ALTER TABLE option 




Eileen La Fond
Phone (206) 386-0011
e.mail Eileen.LaFond@xxxxxxxxxxx

** To leave the list, click on the immediately-following link:-
** [mailto:program-l-request@xxxxxxxxxxxxx?subject=unsubscribe]
** If this link doesn't work then send a message to:
** program-l-request@xxxxxxxxxxxxx
** and in the Subject line type
** unsubscribe
** For other list commands such as vacation mode, click on the
** immediately-following link:-
** [mailto:program-l-request@xxxxxxxxxxxxx?subject=faq]
** or send a message, to
** program-l-request@xxxxxxxxxxxxx with the Subject:- faq

Other related posts: