On one of our customer we had to move all nonclustered indexes to another filegroup and we have found a solution for it and I …

What is Read Only Tables in Oracle? It is possible to use read only tables in Oracle databases starting from 11.1. You can not update …

When trying to send an e-mail with the UTL_MAIL package, the error “ORA-06502: PL / SQL: numeric or value error” is received when the smtp_out_server …

In Oracle databases, when the downgrade operation or “migrate schema” operation is done through adrci, when using the adrci, ORA-48318 error is received when the …

When you create backups with rman in Oracle 12.2 databases, an “RMAN-10038: database session for channel d1 terminated unexpectedly” error occurs. You see the error …

You can run rman in debug mode to get more detailed information about Rman operations. In this way, we get more detailed information about a …

With the new feature that introduced with Oracle 18c, it is now possible to stop the running query in a session without terminating session. You …

In Oracle 12c and later versions, auditing is possible with Unified audit as well as standard auditing. This feature allows role-based auditing. It is possible …

With Oracle 12.2.0.1, SQL * Plus is capable of displaying the result of a query as CSV. Its use is as follows. [crayon-673fd5c76b377746152828/] Options DELIMI[TER] …

if your Oracle client version is 11.1.0.7 and you use Oracle 12.2 databases with a patch applied after April 2018 PSU, you receive an error …