How Can DBMS_XPLAN.FORMAT_SIZE Be Useful For You?
October 6, 2019At one of the presentations I attended this year at Oracle Open World, the speaker Franck Pachot, had an interesting… Continue Reading
My First Oracle Open World Experience
September 25, 2019Last week I was fortunate enough to attend the Oracle Open World 2019 Conference, or in other words OOW19. If… Continue Reading
Fix ORA-04095: Trigger Already Exists On Another Table
September 10, 2019One of my readers asked me what is the cause of the following error, and what is the work around… Continue Reading
Three Reasons To Use Bigfile Tablespaces
September 5, 2019Summer is almost over, kids go back to school, we go back to work, and settle back into our usual… Continue Reading
What To Do When The Export Fails With ORA-01466?
August 7, 2019The nightly backup job you have scheduled for your database, the datapump export job, starts failing with the following error:… Continue Reading
What Backup Jobs Are Currently Running
July 24, 2019You’ve planned to do some maintenance for the RMAN catalog, which would result in an outage to the RMAN catalog.… Continue Reading
How To Use Datapump Between Different Database Releases
July 17, 2019Imagine that you are asked to provide a datapump export of your database which is to be imported somewhere else.… Continue Reading
Oracle’s Recycle Bin: Security Considerations
July 10, 2019I planned last week’s post to be the last one on the recycle bin. And then I got a nice… Continue Reading
Oracle’s Recycle Bin – Part 2
July 3, 2019Last week we explored the purpose of the recycle bin, what goes into the recycle bin and how to bypass… Continue Reading
Working With Oracle’s Recycle Bin
June 27, 2019One of the greatest things that Oracle added to its database, in version 10g, was the recycle bin. What I… Continue Reading