I'm trying to rename a constraint (

[ofsouto]

I'm trying to rename a constraint (primary key) and a message shows up: ORA-14155 missing PARTITION or SUBPARTITION keyword. What can I do to rename constraints (primary and foreign keys)?

ALTER TABLE table_1 RENAME CONSTRAINT constraint_old_name TO constraint_new_name;

Oracle 8i (8.1.7 Release).

Thanks in advance.

 

[rohanem]

I dont think you can rename constraints.You will have to drop it and create a new one.

Thanks
Rohan

 

[cassandra]

If your tables currently have data then you can't drop them but you can modify.

Try this: ALTER TABLE (TABLE1 MODIFY(COLUMN DATATYPE CONSTRAINT CONSTRAINT_NAME));