Data compression is a feature offered by many modern databases like Db2, Oracle, MySQL, MariaDB and SQLServer. However, many companies do not use this feature in their database systems. Either they lack the knowledge of its existence in the application/systems design phase or due to budget issues.
In this article, we are highlighting the methods that three of our Oracle Certified Experts used to make their way in the Oracle world. Learn how to start in IT, how to grow your career in Oracle, and where the industry is going in the next five years.
In this article, we will see how we can automate the process of moving Oracle metadata to version control system, in my case I am using GIT using a simple shell script to avoid manual intervention.
In this article, I will be sharing the issues that we faced while converting the data type and NLS semantic to CHAR from BYTES. This was one of the business use cases where we needed to convert the entire columns throughout the schema from BYTES to CHAR types only for VARCHAR2 columns datatypes.
This article will show a step by step guide on how to mask column values in Oracle 12c using DBMS_REDACT full redaction option. This option is available on licensed Oracle Enterprise edition as part of Oracle's Advanced Security.