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

  In the era of digitization, information availability online has witnessed an exponential surge. The internet is brimming with textual content—be it emails, web pages, …

Error: [crayon-67d9d8c048456923348501/] Environment variable ORACLE_UNQNAME not defined. Please set ORACLE_UNQNAME to database unique name. Solution: It should be set as follows. ORACLE_UNQN average = XXXX …

  If you want to make a change in more than one session database at the same time, the control to prevent sessions from adversely …

HADOOP MULTI NODE INSTALLATION PROCESS [ Note: I am creating multi node in most easiest way by creating and using everything in root mode on …

  You can get the below error when you run the ADDR AWR report in the Oracle Standard edition database. “ORA-13716: Diagnostic Package License is …

  Lock Compatibility provides the necessary control when multiple transactions have the same lock request (row, page). If the resource is previously locked by a …

  Some time we are facing issue like we forgot the MySQL root password. So here we are providing just some simple steps to reset …

  SQL Server implements different types of locks that determine how concurrent query requests access the data. For example, imagine that one user wants to …

Problem: If a disk previously included in an ASM disk group is attempted to be used for another disk group, it will fail with the …

  Adding Space to Sybase IQ server Little background about IQ space. In IQ 15.0 Dbspace != dbfile Under one dbspace we can have many dbfiles …