Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux

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-6741199a70d29439802668/] 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-6741199a7145b815370986/] 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 …

If you enable the unified audit feature announced with 12c, all audit records will be in the UNIFIED_AUDIT_TRAIL table. Logon failure records will not be …

I will share an example that creates partition on JSONB column in PostgreSQL in this article. But first we need to know What JSON and …

If you want to learn What the Redo Log is, you should read the article named “Oracle Redo Log And Archive Log”. I will tell …

What is the SYSAUX Tablespace and What is it used for? In Oracle databases, SYSAUX tablespace is an auxiliary storage space for SYSTEM tablespace. Most …

What is Redo Apply? Redo Apply performs the task of creating a block-by-block copy of the Primary database. The operations are as follows; The RFS …