Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-01735:Invalid alter table option

645691Jun 18 2008 — edited Jun 18 2008
I try to execute this following generic command

ALTER TABLE generic_table_name
ADD CONSTRAINT FK_generic_table_name
FOREIGN KEY (column_name)
REFERENCES generic_table_name2(column_name)
USING INDEX TABLESPACE tablespace_name

The system reply error : ORA-01735

The following similar command

ALTER TABLE generic_table_name
ADD CONSTRAINT PK_generci_table_name
PRIMARY KEY (column_name)
USING INDEX TABLESPACE tablespace_name

is done.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 16 2008
Added on Jun 18 2008
1 comment
19,736 views