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 …
Read More »
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 …
Read More »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 …
Read More »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 …
Read More »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 …
Read More »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 …
Read More »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 …
Read More »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 …
Read More »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 …
Read More »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-67a74deef3d39210395253/] Options DELIMI[TER] …
Read More »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 …
Read More »