ORACLE

You can read this document to access the tables in the MSSQL database using the DBLINK architecture from the Oracle database. Please test in 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-676c519531dc1702540339/] Options DELIMI[TER] …

This article contains information about Oracle User Operations like creating a new Oracle user, authorizing, changing password and dropping Oracle User. Create Oracle User CREATE …

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 …

Whether the ARCHIVE Logs are transferred to Standby can be seen from the ALERT LOGs as follows. [crayon-676c5195321c2552970593/] After the archives are created, sometimes writing …

This article contains information about Oracle SQL Plus tool. What is Oracle SQL Plus? SQL Plus is a tool for managing the database management system …