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

During the connection to Oracle 12.2 databases, this error is occurring due to the older client version of the client and the connection cannot be …

If a data file in the ASM disk group does not belong to the system tablespace, it is possible to move it to a different …

In this article, we’ll examine the Distributed Partitioned Views, which we can combine data from tables on multiple instances with UNION ALL. If you combine …

As you know, partition is the division of large tables into small tables. For more information about Partition, please read the article “How To Create …

In case of a damage of the flash modules(fmod) on flash cards on Exadata cellnodes, the flash cache will not function normally and there will …

You can receive this error when you want to get a total result by using the SUM function. In order to avoid this error, you …

You can perform the hard disk replacement on Exadata cellnodes by performing the following checks and steps. Hard Disks on the cell node are automatically …

The Remote Diagnostic Agent (RDA) is a tool provided by Oracle that collects data about your database environment and reports it as a web page. …

In PostgreSQL, you may need to review more than one thing to analyze database or whole cluster when you encounter a problem. For example, a …

Description: As we know, we can’t create a function-based index on MySQL, not like PostgreSQL (https://www.postgresql.org/docs/current/indexes-expressional.html). Usually, we should avoid using functions in the where …