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 reference usable when connectiong to one autonomous database but if we need to use several […]
Read more "SQL*Plus Client connections to several Oracle Autonomous (Always-Free)"
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. We use a table with 9 000 000 rows and seelct from it with a […]
Read more "Overview: SELECT SAMPLE"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 way to estimate the space benefits of defragmenting the tablespace. I will use two methods: […]
Read more "Estimate Defragmentaton Benefits for a Bigfile Tablespace"
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"
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"
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)"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"