Column Level Encryption In this use case, we have built encryption infrastructure on the database and developers encrypted some columns. Now we would like know… Read More »How to List Encrypted Columns
Tablespace Level Encryption In this use case, DBA has done encryption infrastructure and create some encrypted tablespaces in the database. Now we would like to… Read More »How to List Encrypted Tablespaces
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 Create Case-Insensitive Unique Index
Unresponsive DB Link A dead DB link means an unresponsive remote connection between databases. In fact, the db link may have finished his job without… Read More »How to Resolve DB Link Hang or Die
RMAN-01009 There're several error patterns that throw RMAN-01009 during RMAN statement execution. found "database" found "list" found "identifier" RMAN-01009 means that the word at the… Read More »How to Resolve RMAN-01009: syntax error: found