At times, while we want to get a list of tables and their columns along with their data types from Oracle. It is not so efficient to useDESC <tablename> for all the tables one after another. I had a similar requirement and I came to know that DESC does not[...]
Read more
The Beautiful thing about Digital world is that we have a Ctrl+z button, snapshots and backups to go back in time and correct our mistakes, which is not possible in our real life. Enough with a philosophy. I would not have to tell you how crucial backups are and when[...]
Read more
I have recently encountered an issue while trying to export the Oracle DB using the expdp command and my database size was huge, therefore I got an error stating that Snapshot is too old When I researched further I noticed that my UNDO_RETENTION was too less and set to 900[...]
Read more