Upper 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 dd: invalid number

by Ed Chen
September 6, 2021March 25, 2022

dd: invalid number: ‘1m’ Tried to replicate a partition to another with dd, but it failed with dd: invalid number. Here I initially use 1g… Read More »

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