Letter Case

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 PRKO-3032 : Invalid instance name(s)

by Ed Chen
January 31, 2022November 11, 2022

PRKO-3032 or PRKO-03032 Tried to start one instance of a RAC database by SRVCTL utility, but it failed with PRKO-3032. [oracle@primary01 oracle]$ srvctl start instance… Read More »

How to Resolve ORA-29760: instance_number parameter not specified

by Ed Chen
December 4, 2020May 14, 2023
4 Comments

ORA-29760 ORA-29760: instance_number parameter not specified means that Oracle cannot find any INSTANCE_NUMBER for given instance names in the parameter file to startup the instance.… Read More »

ORA-00904 Invalid Identifier - Oracle Database Object Name Recognition Examples

How to Resolve ORA-00904 Invalid Identifier

by Ed Chen
March 12, 2019April 20, 2023
4 Comments

ORA-00904 ORA-00904 means that you used an invalid identifier to be a column name, which is most likely unmatched in name or incorrect syntax. Since… Read More »

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