ORA-00001

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-00001: unique constraint violated

by Ed Chen
May 2, 2020January 26, 2022
4 Comments

ORA-00001 There're only two types of DML statement, INSERT and UPDATE, may throw the error, ORA-00001: unique constraint violated. ORA-00001 means that there's a constraint… Read More »

How to Resolve OGG reperror (1403, discard)

by Ed Chen
May 28, 2017December 11, 2022

reperror (1403, discard) Found errors in REPLICAT and caused it stopped. GGSCI (target) 1> info all Program Status Group … Read More »

How to Resolve ORA-00001: unique constraint (PERFSTAT.STATS$SQL_SUMMARY_PK) violated

by Ed Chen
January 7, 2017May 17, 2023

STATSPACK ORA-00001 Login as PERFSTAT and took a snapshot like the following statement. But it failed with ORA-00001. SQL> exec statspack.snap(i_snap_level=>5); BEGIN statspack.snap(i_snap_level=>5); END; *… Read More »

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