Scripts to Upgrade DB using Export/Import Datapump – Part 1
September 8, 2020In my last blog post, I was showing you one way to upgrade a database to 19c (or to any… Continue Reading
Tag: Oracle
Does SQLNET.ALLOWED_LOGON_VERSION_SERVER Parameter Affect the Password Version?
August 20, 2020That is a great question! But before answering it, let’s look at what the password version is, and what the… Continue Reading
DBMS_QOPATCH How to List the Patches Applied Without Connecting to the Database Server
August 3, 2020Ever wondered how to check what patches are installed for a database home, without actually having access to the database… Continue Reading
Two Occupants That Affect The Most SYSAUX Tablespace Size
July 25, 2020Is you SYSAUX tablespace running out of space? Are you wondering what is causing the tablespace growth? Normally you would… Continue Reading
Things You Might Not Know About the Compression Advisor
June 28, 2020Last week I received an email from one of my readers, and long time DBA colleague, Wayne, about an interesting… Continue Reading
Create Indexes When Importing Table With a Different Name
June 9, 2020Last week we discussed about overcoming the ORA-39034 Table TABLE_DATA: X does not exist, when importing data with the REMAP_TABLE… Continue Reading
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