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

  We may need to keep passwords in databases for some reason, and we don’t want anyone to see them, including dba. In postgresql there …

  The partition of the disk to be allocated to ASM should not start from the 0th cylinder. You must start at least from the …

  We use letters like C, D, E when defining disks on “Windows Server”. If the number of our disks increases, we may not be …

  HI Guys, We were put in a Situation that we had to Create the New data files  for the tablespaces in the RECO diskgroup …

  If the Oracle UNDO table space is corrupted, it may be possible to get the error as follows. ORA-00376: file string cannot be read …

  I explained how to change the disks of a normal database in the article “How To Change The Disk Of Database Files On SQL …

  In MySQL, views are not only query-able but also updatable. It means that you can use the INSERTor UPDATE statement to insert or update rows of the base table through the …

  The generated AWR baselines cause the snapshots to be stored, so you will not be allowed to delete old snapshots. Therefore, it is necessary …

  With SQL Server Startup Parameters, the location of certain files in the startup phase of the SQL Server service, and some conditions in the …

  Note: These tips were based on upgrades from 11.2.0.4 to 12.1.0.2 (Linux and Solaris ONLY) OS user grid was the “owner” of the Grid …