Database: Oracle Database 19c Enterprise Edition Release 126.96.36.199.0 – Production Version 188.8.131.52.0 I write this post in order to follow step by step how a bigfile tablespace is created and managed in 19c. The main purpose is to find a way to estimate the space benefits of defragmenting the tablespace. I will use two methods: […]Read more "Estimate Defragmentaton Benefits for a Bigfile Tablespace"
Database cloning, very handy feature, is now available for Oracle’s Autonomous Cloud. Quite easy to implement, too: The options are:Read more "It is now possible to clone a database in Autonomous Cloud"
First introduced in 12.2 . It basically determines how the string comparison takes place. In order to use the feature, extended data types should be enabled, I work on an great autonomous TP instance and it is already enabled: The feature is supported at different levels: column table schema session database statement In this post, […]Read more "Column Level Collation Example"
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. Using SQL Developer in a foreign, non-English language was […]Read more "Starting Oracle SQL Developer with Custom Parameters"
In DEVONthink, it is quite easy to create and update own templates. They are all stored in:Read more "DEVONthink Templates"
a. First step is the database creation. Quite straightforward: b. Next step is to a connection setup connection from local client: from the main datbase page we click the DB Connection button and download the client credentials: A zip archive will de downloaded into your local client machine. In my case, the file is called: […]Read more "Oracle Autonomous Transaction Processing: Client Setup"
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 The installation is quite simple but we need to rememeber that, in order to have a functional client for a DBA we would need to download three packages at least: Basic Package – […]Read more "Oracle Instant Client for macOS (Intel x86)"
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 […]Read more "Remove Last Character of Each Line"
Keep pressed option key (alt) and click on the Notifications icon which is usually found on top right corner. Easy!Read more "Turn On ‘Do Not Disturb’ mode on mac OS X"