When we get a backup with Rman, if there is a damaged block on a datafile, the ORA-19566 error will be received and the backup …
Read More »dbtut
Running an Existing Job Using Maintenance Plan
We perform maintenance operations on SQL Server using Maintenance Plan. In this article I will describe the process of running a sql server job. I …
Read More »Chained Row Analysis
A chained row is called a row that does not fit into a single database block. For example, when you try to add a …
Read More »Deleting Maintenance Plan History
We perform maintenance operations on SQL Server using Maintenance Plan. This article describes how to delete the maintenance plan history. I will share links to …
Read More »GRANT, REVOKE and DENY Commands in SQL Server(TSQL)
You can use GRANT, REVOKE, and DENY commands on many database objects in SQL Server. With the GRANT command, you can authorize a user. With …
Read More »Data Pump, expdp ORA-39127, ORA-01031, ORA-06512 Errors
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 »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 »