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

Each database administrator wants to detect and delete unused logins. By default in SQL Server, the last time the login was logged is not stored …

To move all objects in a schema to a different schema, the following steps must be followed. The following queries prepare the queries required for …

Policy-Based Management is a feature that is introduced with SQL Server 2008. It allows us to set the rules we want in our systems, to …

During the 12c database creation process , you can see ORA-20001 error in the alert log file when the “SYS.ORA $ AT_OS_OPT_SY_ <NN>” auto job …

Policy-Based Management is a feature that is introduced with SQL Server 2008. It allows us to set the rules we want in our systems, to …

In Oracle 12c databases, datafile can be moved online. In earlier versions this was not possible. With 12c, a datafile can now be moved from …

Policy-Based Management is a feature that is introduced with SQL Server 2008. It allows us to set the rules we want in our systems, to …

When Data pump is running slowly or when it is hanging, determining which query is currently running will help in understanding the problem. The following …

Policy-Based Management is a feature that is introduced with SQL Server 2008. It allows us to set the rules we want in our systems, to …

You can access summary information about the status of Data Pump Master and worker processes with the following query. [crayon-607d940082e7d372406430/] You can also find out …