Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
In the DBA_TAB_MODIFICATIONS table, change statistics for all changed tables in the database are stored. The same information can also be accessed from the …
Read More »dbtut
How To Find SQL Server Database Compatibility Level
In this article I will share the information of finding database compatibility level. If may want to read more about SQL Server Compatilibility Level, …
Read More »CREATE FILE encountered operating system error 32(The process cannot access the file because it is being used by another process.) while attempting to open or create the physical file
ERROR MESAGGE: CREATE FILE encountered operating system error 32(The process cannot access the file because it is being used by another process.) while attempting …
Read More »How To Recover Dropped Tables with Oracle Recyclebin
In this article I will tell you about Recyclebin which is one of the beautiful features announced with Oracle 10g version. With the Recyclebin …
Read More »What is SQL Server Database Compatibility Level and How To Change Database Compatibility Level
The Compatibility Level sets some database behaviors to work in accordance with the specified version of SQL Server. For example, for compatibility levels in …
Read More »ORA-00245: control file backup failed; target is likely on a local file system
When backup is taken with Rman, it creates the snapshot of the control file and uses it as backup file. The name of the …
Read More »SQL Server Databases Are Not Appearing While Creating a New Protection Group(SQLServerWriter does not appear as a result of the vssadmin list writers command)
Before you read this article, I suggest you read articles “How To Install DPM Agent For SQL Server” and “How To Backup SQL Server …
Read More »How To Backup SQL Server Databases with DPM
Before reading this article, you need to read the article “How To Install DPM Agent For SQL Server” and make the necessary installation. After …
Read More »How To Install DPM Agent For SQL Server
To be able to back up the SQL Server databases with DPM, the DPM Agent must be installed on the SQL Server servers via …
Read More »Data Pump Export process waiting with the message “wait for unread message on broadcast channel”
During the DataPump export process, if the relevant session is waiting for the following message, you can resolve this issue by doing the following …
Read More »