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"
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)"
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"
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"