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

Note: First try below steps on test or non-prod server. Keep software ready and accessible. root access required to install binaries. create new mount point …

Error: During RMAN backup, you can see the following errors. ORA-00245: control file backup operation failed RMAN-08132: WARNING: can not update recovery area reclaimable file …

  Introduction MySQL, the most popular Open Source SQL database management system developed, distributed, and supported by Oracle Corporation. In this article we’ll go over …

Error: When connecting to RMAN, it generates output when any command is given, but the command is not completed and is waiting. Reason: Disruption in …

  In some cases, there may not be enough space on the disks where the database files are located. For this reason, you may need …

Error: When we try to create a file in NFS mounted directory we get an error like this and we can not create the file …

General Concepts: First of all, the database has two files by default. These are data file with mdf extension (called Primary Data File) and transaction …

I described creating an updateable view in the article “How To Create an Updatable View in PostgreSQL“. In this article I will describe how to …

In PostgreSQL, we can perform insert, update and delete operations on the relations specified in the view via views. Restrictions Of course there are some …

When designing a database, it is necessary to analyze the disk requirement correctly and determine the size of the disks from the beginning. Sometimes things …