I recently worked at a Client that had the Windows desktop setup in a non-English language. Naturally, I did not get admin rights on the Client owned desktop so I could not change the sqldeveloper.conf SQL Developer config file which was stored in a ‘protected’ location.
Continue reading “Starting Oracle SQL Developer with Custom Parameters”DEVONthink Templates
In DEVONthink, it is quite easy to create and update own templates. They are all stored in:
~/Library/Application Support/DEVONthink Pro 2/Templates.noindex
It is now possible to clone a database in Autonomous Cloud
Database cloning, very handy feature, is now available for Oracle’s Autonomous Cloud.
Continue reading “It is now possible to clone a database in Autonomous Cloud”
Oracle Autonomous Transaction Processing: Client Setup
a. First step is the database creation. Quite straightforward:
Continue reading “Oracle Autonomous Transaction Processing: Client Setup”
Oracle Instant Client for macOS (Intel x86)
Oracle does not release anymore full client packages for the Mac clients. Therefore, we need to use the Instant Client from:
https://www.oracle.com/technetwork/topics/intel-macsoft-096467.html
Continue reading “Oracle Instant Client for macOS (Intel x86)”Remove Last Character of Each Line
I had to modify a file for loading into an Oracle database with SQL*Loader. The file was using as field delimiter the | pipe character and each line was ending in a |. So ideally, I would like to remove the pipe chracter that ends each of the 384 016 850 lines of my text file.
Continue reading “Remove Last Character of Each Line”Creating a Table for Exchange With a Partitioned Table
Turn On ‘Do Not Disturb’ mode on mac OS X
Keep pressed option key (alt) and click on the Notifications icon which is usually found on top right corner. Easy!
Disable Mac OS X Gatekeeper
Ocassionally, there is a need to install an app created by a developer that is not identified by the security policy in place on the Firm’s MacBook.
Continue reading “Disable Mac OS X Gatekeeper”