Asynchronous Global Index Maintenance and Recycle Bin
Got an Oracle error ORA-38301: "can not perform DDL/DML over objects in Recycle Bin" in the alert log.
2017¶
SQL*Plus 12.2 and searching path of login.sql
Having installed Oracle Database 12.2 on a client, I have noticed that the login.sql script, which is placed in a custom directory specified by SQLPATH, is not invoked anymore.
ORA-3180 on Active Data Guard standby database
Got a call asking me to provide advice on the cause of ORA-3180 error on an Active Data Guard standby database instance
DBMS_METADATA.GET_SXML_DDL may produce incorrect DDL for trigger in EBR environment
I have recently discovered a case when DBMS_METADATA.GET_SXML_DDL returns incorrect DDL for a trigger in an EBR environment.