CREATE UNIQUE INDEX

Create Case-Insensitive Unique Index in Oracle

by Ed Chen
April 29, 2022May 27, 2023

Case Insensitive Index Using unique case-insensitive constraint in a column sometimes is reasonable in business logic to prevent duplicate items. Let's see a table that… Read More »

How to Resolve ORA-01502 Error Message

by Ed Chen
June 12, 2021February 6, 2023

ORA-01502: index or partition of such index is in unusable state ORA-01502 means that the index that the optimizer want to use is in UNUSABLE… Read More »

How to Resolve ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found

by Ed Chen
December 28, 2019December 10, 2022

ORA-01452 ORA-01452 means that the unique index that you want to impose on columns cannot be created because of duplicate keys have been found. In… Read More »

JavaScript is not enabled. Please enable it and reload the page.