Three Reasons To Use Bigfile Tablespaces
Published: Fri, 09/06/19
Summer is almost over, kids go back to school, we go back to work, and settle back into our usual routine! The blog posts are back as well! I’d like…
Diana Robete
database advise, step by step guides, how to emails
What To Do When The Export Fails With ORA-01466?
Published: Thu, 08/08/19
The nightly backup job you have scheduled for your database, the datapump e port job, starts failing with the following error: ORA-31693: Table data…
What Backup Jobs Are Currently Running
Published: Thu, 07/25/19
You’ve planned to do some maintenance for the RMAN catalog, which would result in an outage to the RMAN catalog. The only challenge is, you do not…
How To Use Datapump Between Different Database Releases
Published: Thu, 07/18/19
Imagine that you are asked to provide a datapump e port of your database which is to be imported somewhere else. The biggest mistake that can happen…
Oracle’s Recycle Bin: Security Considerations
Published: Thu, 07/11/19
I planned last week’s post to be the last one on the recycle bin. And then I got a nice surprise, Daniel Morgan, from morganslibrary.com, made a…
Oracle’s Recycle Bin – Part 2
Published: Thu, 07/04/19
Last week we e plored the purpose of the recycle bin, what goes into the recycle bin and how to bypass the recycle bin. This week we’ll e plore how to…
Working With Oracle’s Recycle Bin
Published: Fri, 06/28/19
One of the greatest things that Oracle added to its database, in version 10g, was the recycle bin. What I like about the recycle bin is the piece of…
How To Fix ORA-31600 During Import Datapump
Published: Thu, 06/13/19
One day I was trying to run an import datapump job, and it kept failing. The error was pointing to one of the parameters being incorrect. ORA-39005:…
Understanding Why ORA-04021 TIMEOUT OCCURRED WHILE WAITING TO LOCK OBJECT Happens
Published: Fri, 06/07/19
One of my readers asked me if I could write about locking and blocking in the database, more specifically about the following error: ORA-04021:…
Step By Step Example Of Working With DBMS_ERRLOG
Published: Thu, 05/23/19
Last week I showed you a cool tool available since 10.2.0.1, that not every DBA is aware of. I was not aware of it either. The package I am talking…