Not Possible to Create Primary Key With More Than 4 Columns in Sql Developer (Doc ID 2890604.1)

Last updated on AUGUST 24, 2022

Applies to:

Symptoms

ACTUAL BEHAVIOR
---------------
It is not possible to create primary key with more than 4 columns in Sql Developer.

EXPECTED BEHAVIOR
-----------------------
To be able to add as many as needed columns in the "Prompts" tab.

STEPS
-----------------------
The issue can be reproduced with the following steps:

1) Use the connections navigator in SQL*Developer and navigate to-> Tables;
2) Right click on a table with more than four columns;
3) Select -> Constraints -> Add Primary Key...
4) Try to create a PK with more than four columns.

Changes

 None.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.