How to List Encrypted Columns
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
How to List Encrypted Tablespaces
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
How to Resolve DataPatch Error at line 0: Could not open logfile
apply: WITH ERRORS When we are close to the end of datapatch, we saw an OS error: Error at line 0: Could not open logfile.… Read More »How to Resolve DataPatch Error at line 0: Could not open logfile
How to Resolve ORA-20016: Unable to get the lock : get_pending_activity : 1
ORA-20016 Tried to do a datapatch (SQL apply) against a database, but it failed with ORA-20016: Unable to get the lock. C:\Users\Administrator>datapatch -verbose ... Error:… Read More »How to Resolve ORA-20016: Unable to get the lock : get_pending_activity : 1
How to Create Case-Insensitive Unique Index
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
How to Insert Multiple Rows in One Statement
Multiple Rows Insert To insert rows into a table, you can do it one by one. insert into fruits values ('Apple', 2); insert into fruits… Read More »How to Insert Multiple Rows in One Statement
How to Resolve DB Link Hang or Die
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
How to Resolve RMAN-01009: syntax error: found
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
How to Install Oracle Database 11.2.0.1 on Enterprise Linux 5 - 4 of 4 - Database Creation
D. Oracle Database Creation [oracle@primary01 ~]$ dbca
How to Install Oracle Database 11.2.0.1 on Enterprise Linux 5 - 3 of 4 - Listener Installation
C. Oracle Listener Installation [oracle@primary01 ~]$ netca We are ready for next phase, Oracle database creation.