I wanted to drop all
the tables in a particular postgres database, there were around 90 tables,
dropping individual tables one by one is not a good idea and is time-consuming
as well,
So decided to create a DROP script and then execute it, the challenge for me
was to spool the file in PSQL as it is slightly different from SQL language
In the...
MySQL 8.0 New Features
MySQL 8.0 is released with lot of new features, we will discuss those in short, please visit official website for details of the features
Features can be divided in 3 types, in this post will discuss features added in MySQL 8.0, including...
Oracle RMAN : Incrementally Updated Backups
We have learned about incremental backups and how to make these incremental backups faster. Now we will discuss incrementally updated backups
Assume we have very huge size database say around 50-60TB, there are few challenges we may face...
Oracle : The oerr Utility (Oracle Error)
The oerr utility (oracle error) is provided only with Oracle
Database on UNIX platform
oerr is not an executable, but instead a shell script that retrieves
messages from installed message files
oerr is not provided on windows, since it uses...
Oracle : Drop Pluggable Database (PDB) in 12c/19c/21c/23c
After learning creating pluggable database, we will discuss about dropping pluggable database(PDB) in 12c, 19c and above versions
Dropping pluggable database is similar to dropping any other regular database, you have two options while...
The DUAL table in oracle
Everyone must have came across DUAL table present in oracle database, most of DBA's are using it daily but do not know what exactly it is, here we will discuss about the same
DUAL table is special one row one column table available by default...