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
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
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
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
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
D. Oracle Database Creation [oracle@primary01 ~]$ dbca
C. Oracle Listener Installation [oracle@primary01 ~]$ netca We are ready for next phase, Oracle database creation.