Change location of control files in Oracle
Hello everyone, we are going to comment on one of the actions that as DBAs we are going to have to perform sometime if we work in database environments Oracle …
Autonumerics: get the latest embedded in Oracle, MySQL, and SQL Server
Hi friends!!! In today’s post we are going to work with Autonumerics in Oracle, MySQL and SQL Server . We will see how to obtain the last value of the …
SQL Macros in Oracle Database 21c
Hello everyone. Today we wanted to discuss with you one of the new functionalities of Oracle 21C (although we have already started to see it from the 20th with limitations), …
Bug when creating a DB in RAC with dbca
Hello everyone, today we are going to talk about a bug that happened to our team in a client a few days ago. Occurred when creating a DB in RAC …
Virtual columns in Oracle. Use and limitations
Hello everyone, today we wanted to refresh with you a utility of Oracle that although it is very powerful we usually use it little, virtual columns . Virtual columns are …
Put a DB in Archivelog mode in Oracle
Hello everyone, today we are going to propose a task that when we have an Oracle DB we will have to perform, or at least think about it, which is …