Database: Oracle Database 19c Enterprise Edition Release 18.104.22.168.0 – Production Version 22.214.171.124.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"
In DEVONthink, it is quite easy to create and update own templates. They are all stored in:Read more "DEVONthink Templates"
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"
https://docs.oracle.com/database/122/VLDBG/maintenance-partition-tables-indexes.htm#GUID-2DE24EE4-00EB-4D58-A428-8E6CBD7E7F34Read more "Creating a Table for Exchange With a Partitioned Table"
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"
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. Here is the short procedure I identified it works for me: in terminal type: sudo spctl –master-disable verify with: spctl –status open the application and quit it in terminal, type: sudo […]Read more "Disable Mac OS X Gatekeeper"
https://livesql.oracle.com/apex/f?p=590:1000:100225800561367Read more "Oracle Live SQL Tool"
ORA-14047: ALTER TABLE INDEX RENAME may not be combined with other operations When we try to rename a table or index name in Oracle, we use a simple command as following If we put into schema names to this command, we can encounter ORA-14047 error.This error raises when we put schema name in front of […]Read more "Strange error when renaming a table"