Troubleshooting ORA-39034: Table TABLE_DATA: X does not exist.
May 27, 2020Have you received “ORA-39034: Table TABLE_DATA: X does not exist“, while executing an import operation? Were you scratching your head,… Continue Reading
How To Move Datafiles Online Quickly?
May 21, 2020Last week was the launch of my new course on Udemy! I would like to thank you all for your… Continue Reading
What Is Shadow Lost Write Protection And How To Enable It
May 4, 2020Shadow Lost Write Protection was introduced in 18c, and of course is available with 19c as well. Data block lost… Continue Reading
Quick and Easy Steps To Change Database Name
April 24, 2020When was the last time you had to change the name of a database? Long time ago, changing the database… Continue Reading
4 Things About Schema Only Accounts You Should Know
March 28, 2020Let’s continue learning about 19c. Some of the things I’ll talk about are not new to 19c, however they are… Continue Reading
Stay Safe, Stay Healthy, Stay Positive, Stay Inside
March 20, 2020These are unprecedented times that we live in! I just wanted to send word out to my readers to stay… Continue Reading
How To Quickly Terminate A Session Or Cancel A SQL Statement
March 5, 2020Terminating sessions is something that DBAs are asked to do pretty often.Usually the request comes in the form of an… Continue Reading
Four Ways to Startup or Shutdown Your 19c Database
February 20, 2020Can you use Oracle Enterprise Manager Database Express, or Oracle Cloud Database Express to startup or shutdown your database? Think… Continue Reading
SQL Quarantine In Action On Your Laptop
February 14, 2020Last week I gave you a taste for SQL Quarantine. Some of you asked me if I know when this… Continue Reading
Intro To SQL Quarantine
February 6, 2020In the last blog post we talked about Quarantined Objects, which have no relationship whatsoever with today’s topic. I just… Continue Reading