In this entry we are going to describe how to apply a patch to our database. In this example, our database is at version 19.3.0.0.0 and we are going to apply the patch 19.20.0.0 (Patch 35320081: DATABASE RELEASE UPDATE 19.20.0.0.0.0), although the procedure is usually similar I always recommend to read the README of the patches [...]
Apply patch 19.20.0.0.0 on Oracle Database Read more "
Oracle has introduced a new, much faster and more interactive Error Portal. In this document we show you how to configure it so that it can be used with the intelligent search function of the main browsers, such as Chrome. That is to say, with this configuration you will have a mechanism where typing a predefined shortcut (normally
Error Help Portal - Oracle Database Read more "
In version 19c Oracle introduced a very interesting feature, giving the administrator the possibility to create tables where only insert operations are allowed, where the deletion of rows is forbidden or can be restricted for a set time, as well as it is possible to restrict the deletion of a table. It is also possible to restrict the deletion of a table.
Avoid drop and deletes in Oracle tables (Blockchain Tables) Read more "
DBNEWID is a database utility that allows you to change the internal identifier of a database (DBID) and the database name (DBNAME). You can change only the DBID, the DBNAME, or you can change both the DBID and the DBNAME. This action before the appearance of the
Change the DBID and the name of a database with DBNEWID Read more "
Sometimes it is necessary to hide (obfuscate) our PL/SQL source code, especially for security reasons, when, for example, we share our code with third parties, for this purpose we have traditionally used the WRAP tool, which we detail in this article. From version 10g R2 onwards, it is possible to perform this action with the DBMS_DDL.WRAP package,
Hide / obfuscate PL/SQL code (WRAP) Read more "
