(Syed Jaffar Hussain) Oracle Database Vault was configured on RAC database v11.2.0.3 and appropriate permissions given to allow the regular duties, such as data pump export/import etc.

(Martin Bach) This is an interesting observation I wanted to share. I have a feeling as if there didn’t seem to be too much information out there for RAC One Node (RON) users, and I hope this helps someone thinking about patching his system.

(Dimitri Gielis) Oracle Application Express (APEX) 18.1 has been out now for a couple of days.

(Skant Gupta) In this post, we will export and import the database link with data pump in Oracle 18c. In next post, we will demonstrate to prevent the passwords of database link using keystores.

(Maarten Smeets) Automating the Oracle JDK installation on RHEL derivatives (such as CentOS, Oracle Linux) and Debian derivatives (such as Mint, Ubuntu) differs. This is due to different package managers and repositories.

(Martin Berger) Recently I had a request to check “if there is any problem with the database at “.

(stewashton) My generic PIVOT function only allowed one column in the FOR clause. The modestly named “Advanced” function has no such limit.

(Bobby Durrett) I have a couple of Oracle performance reports that I upload from my work Windows 7 laptop to our corporate SharePoint site on Office 365 on a regular basis. I thought that it would save me time to automate the uploading of these reports using Python.

(Skant Gupta) In this post, we will create a schema-only user or we can say that user with no authentication, this feature introduced in Oracle 18c. Sometimes developers want to create a user which contain data only but not allowed to log in.

(Andrejus Baranovskis) Did you ever wondered how to get all changed rows in the transaction, without iterating through entire row set? It turns out to be pretty simple with ADF BC API method – getAllEntityInstancesIterator, which is invoked for Entity Definition attached to current VO.