If you are getting the error while dropping a tablespace, please follow the steps to solve the issue. SQL> drop tablespace USER_TBS including contents and datafiles;drop tablespace USER_TBS including contents…
You should know at first what is AWR Report. So, AWR stands for Automatic Workload Repository. AWR is a performance Report which collects the data of Oracle database in regular…
Do you know how to get DDL of a dbms_scheduler job under sys schema in Oracle, if you are looking for the same then this article is for you. In…
If you want to create an Oracle CDB using DBCA silent method then you are in the right place. Just go through the article and at the end of this…
Today in this article, we will show you some basic MySQL commands for DBA which will be helpful in your daily basis tasks. Basic MySQL Commands for DBA : 1.…
To enable Virtualization on Windows PCs, you have to access UEFI/BIOS. Virtualization helps your PC to install a different operating system, like Android™ or Linux. Many Windows 10 PCs and…
Do you know how to change Binary Log Location in MySQL? So today in this article, we will learn about this. In our previous article, we have already seen how…
Do you know what is Binary Log in MySQL? Binary logs are transactional logs in MySQL. Whatever changes are made to the database, that is stored in the Binary Logs.…
Oracle client is software that helps to communicate between Oracle database and client applications such as SQL*plus, SQL developer, Putty, or mobaxterm. To download Oracle 19c client, first open the…
Binlogs in MySQL are like transactional logs which are also called binary logs. So whatever changes are made to the database, like any insert, delete, etc that information is stored…