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 …
Read More »RMAN Commands Hanging
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 …
Read More »How To Change The Disk Of Database Files On SQL Server(Detach Attach & Backup Restore Methods)
In some cases, there may not be enough space on the disks where the database files are located. For this reason, you may need …
Read More »ORA-27054: NFS file system where the file is created or resides is not
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 …
Read More »How To Create a Database On SQL Server
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 …
Read More »How To Create an Updatable View WITH CHECK OPTION in PostgreSQL
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 …
Read More »How To Create an Updatable View in PostgreSQL
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 …
Read More »How To Add Another Disk For a Database Without Interruption On SQL Server
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 …
Read More »ORA-12502: TNS:listener received no CONNECT_DATA from client
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: …
Read More »What is Database File Group And How To Recreate Large Tables In Another File Group
In this article, we will first talk about how to configure the file group structure when the database is first created or comes from …
Read More »