Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
The ABS function returns the positive value of a negative number. The return data type is the data type of the input parameter. The ABS …
Read More »kjzdattdlm: Can not attach to DLM(instance crash)
Because the cluster_interconnects parameter is set incorrectly in the database instances on Exadata, one or more of the instances can be closed with the …
Read More »Rebuild System Databases in SQL Server
Because of the problems that occur in the system databases, it is sometimes necessary to rebuild. Rebuild operation resets system databases and allows the …
Read More »JSON text is not properly formatted
If you are processing JSON data and the JSON data is not a valid JSON below error will be occurred. Msg 13609, Level 16, State …
Read More »ORA-14404 error during the drop tablespace operation
If the tablespace that is dropped is empty, but is the default storage space for any partition, the drop operation will cause the ORA-14404 …
Read More »Restore master database in SQL Server
master database is a database that keeps all the information at the system level in an instance. For example, logins, endpoints, linked servers, system configuration …
Read More »JSON Functions in SQL Server(TSQL)
The importance of JSON data type in our lives continues to increase day by day. We will examine the functions that SQL Server provides us …
Read More »How To See Running Queries in Oracle Without TOAD
It is easy to find queries that have been running and that have executed previously during the session using TOAD in the Oracle database. …
Read More »The target principal name is incorrect. Cannot generate SSPI context(Set SPN)
If the domain user that you set for SQL Server Service Account does not have the following rights on the active directory, you will …
Read More »Oracle Database Architecture Part 3
I will continue to explain Oracle database architecture in this article. I’m adding the following image to be memorable. If you didn’t read the previous …
Read More »