Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
When you are backing up with Data Pump (expdp), it may indicate that the privileges are insufficient and may end with errors such as ORA-39127, …
Read More »Updating Statistics Using Maintenance Plan
We perform maintenance operations on SQL Server using Maintenance Plan. In this article I will describe the process of updating statistics. For more detailed information …
Read More »SubQueries in SQL Server(TSQL)
In SQL Server, you can write query in a query. You can write the subqueries in the SELECT section, FROM section, and the WHERE …
Read More »How To Move an Azure SQL Database to a Local Instance
Today a software developer friend has requested to move a database in Azure SQL Database to a local server with its data. What I …
Read More »ORACLE_OCM ORA-12012 ORA-29280
Ora-12012, Ora-29280 errors relate to Oracle configuration manager (OCM). Typically, OCM jobs fail due to the old installation after database upgrade operations. Possible errors …
Read More »Checking Database Consistency Using Maintenance Plan
We perform maintenance operations on SQL Server using Maintenance Plan. In this article I will describe the process of checking the database consistency (dbcc checkdb). …
Read More »IN Operator in SQL Server(TSQL)
When filtering through the Where Clause during data reading from the database, the IN operator can check whether the column is within certain values. …
Read More »Between Operator in SQL Server(TSQL)
When reading data from the database with Between Operator, we can specify a range for the data we filter in WHERE Clause. Let’s make …
Read More »Unable to access the ‘database_name’ database because no online secondary replicas are enabled for read-only access
ERROR: Error: Microsoft ODBC Driver 11 for SQL Server : Unable to access the ‘database_name’ database because no online secondary replicas are enabled for read-only …
Read More »ADR Command Interpreter(ADRCI)
ADR Command Interpreter (ADRCI) is a command-line tool in the fault detection infrastructure of Oracle databases. With ADRCI; We can see the diagnostic data in …
Read More »