KB38257: Error when upgrading Oracle 11g metadata to 9.x on a Windows 2008 machine: ORA-02260: table can have only one primary key
![postgresql - Different behaviour between oracle and postgres regarding alter table primary key command - Database Administrators Stack Exchange postgresql - Different behaviour between oracle and postgres regarding alter table primary key command - Database Administrators Stack Exchange](https://i.stack.imgur.com/eF5qO.png)
postgresql - Different behaviour between oracle and postgres regarding alter table primary key command - Database Administrators Stack Exchange
![SOLVED: CREATE TABLE promotion (gift VARCHAR2(15) PRIMARY KEY, minretail NUMBER(5, 2), maxretail NUMBER(5, 2)); ALTER TABLE promotion ADD PRIMARY KEY(gift); Structure of the PROMOTION table Oracle SQLPlus Name Null? Type GIFT VARCHAR2(15) SOLVED: CREATE TABLE promotion (gift VARCHAR2(15) PRIMARY KEY, minretail NUMBER(5, 2), maxretail NUMBER(5, 2)); ALTER TABLE promotion ADD PRIMARY KEY(gift); Structure of the PROMOTION table Oracle SQLPlus Name Null? Type GIFT VARCHAR2(15)](https://cdn.numerade.com/ask_images/1770abb0f29a4cb3a2639d6ce76b7de4.jpg)