I was analyzing one export taking longer and one big table was not using the Direct Path mode. I tried to export only this table and set the access method using the expdp parameter “ACCESS_METHOD=DIRECT_PATH”. This table was created using Lower case and I struggled for a few minutes to find the right syntax 🙂…

Hi, In the Multitenant architecture, it’s common to have some components installed on the CDB but not installed on the PDB. But for Database Vault, you can have some issues. I was doing a Full export from one PDB and I got the error: Worker unexpected fatal error in KUPW$WORKER.FETCH_XML_OBJECTS [ORA-00942: table or view does…

Hi, I was helping a customer who wanted to be ready to migrate the database to 23c when it becomes available using zero or near-zero downtime upgrade techniques. Besides Oracle Golden Gate, one good technique to consider is using a logical standby database to perform a rolling upgrade of the Oracle Database. Oracle Transient Logical Standby is…

Hi, I was helping a customer who needed to migrate to Oracle Database 19c but still using JDK6 and JDK 7. Using JDK 6 and 7 to connect to Oracle Database 19c is not recommended, as Oracle Database 19c may have compatibility and security features that are best supported by later versions of the JDBC…

ORAdiff is an Oracle tool designed for comparing two Oracle Database releases, not only core releases but also patch levels. It highlights variations in parameters, privileges, users and roles, reserved words, patch fixes, database homes, objects, and more. ORAdiff helps answer some common questions: How frequently does the ORAdiff information get a refresh? It is…

Dreams have a funny way of coming true when you least expect them. After years of hard work, dedication, and unwavering determination, I find myself at the threshold of a new and exciting chapter in my career: starting at Oracle, the company I’ve always dreamt of being a part of. Join me on this journey…