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 »dbtut
Read Only Tables in Oracle
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 »ORA-06502: PL/SQL: numeric or value error
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 »ORA-48318: ADR Relation [HM_FINDING] of version=5 cannot be supported
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 »ORA-00600: internal error code, arguments: [krbebad_1]
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 »How To Enable Debug in rman
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 »Oracle 18c new feature: ALTER SYSTEM CANCEL SQL
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 »Auditing Oracle Roles with Unified Auditing
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 »How To Export Data From SQL Plus to CSV
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-672e79326b2df675670621/] Options DELIMI[TER] …
Read More »ORA-28041: Authentication protocol internal error
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 »