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

  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 …

Error: When clients attempts to connect to the database, they can not connect with the error “ORA-12502: TNS: listener received no CONNECT_DATA from client”. Reason: …

  In this article, we will first talk about how to configure the file group structure when the database is first created or comes from …