Oracle Autonomous is a great service and Always-Free is a nice offering launched at OpenWorld 2019. But what happens if I need to connect via SQL*Plus to two or more ADB from the same machine/terminal? The Oracle documentation provides good…
Read More SQL*Plus Client connections to several Oracle Autonomous (Always-Free)
Database: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.3.0.0.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…
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:
In the previous article, I discussed the main differentiating capabilities of the Autonomous, what makes it special on the market. In this post, I will discuss how are those capabilities implemented. First, a few considerations re implementation of the security…
Read More Is Oracle Autonomous Database the answer to the many database security issues? (II)
There is no surprise that typical Database setups are the main target of the hacking attacks worldwide. The reason is obvious: cracking a database will result in access to the data which is the main 'merchandise' to be shared or…
Read More Is Oracle Autonomous Database the answer to the many database security issues? (I)
The feature was 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…
One feature that many developers and data analysts are not aware of is the SAMPLE function in Oracle. It is quite an old feature (not sure exactly when it was added). Below is a simple example of how it works.…
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…
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: ~/Library/Application Support/DEVONthink Pro 2/Templates.noindex
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…
Read More Oracle Autonomous Transaction Processing: Client Setup
