Due to a design flaw i want to add a column to the primary key:
alter table myTable modify primary key pk_myTable(old_column1, old_column2, new_column)
oracle doesnt accept it? how can i change the pk without removing it, all the FKs that reference it and recreating them all again?




Reply With Quote