Scripts to Upgrade DB using Export/Import Datapump – Part 1
Published: Tue, 09/08/20
In my last blog post, I was showing you one way to upgrade a database to 19c (or to any other version), using the e port and import datapump method. I…
Diana Robete
database advise, step by step guides, how to emails
Upgrade Your Database To 19c With Export-Import Datapump
Published: Thu, 08/27/20
Upgrading the Oracle database to 19c is a very hot topic nowadays! I am not going to give you a speech about why you should do it, I am sure you know…
Does SQLNET.ALLOWED_LOGON_VERSION_SERVER Parameter Affect the Password Version?
Published: Thu, 08/20/20
That is a great question! But before answering it, let’s look at what the password version is, and what the SQLNET.ALLOWED_LOGON_VERSION_SERVER…
DBMS_QOPATCH How to List the Patches Applied Without Connecting to the Database Server
Published: Mon, 08/03/20
Ever wondered how to check what patches are installed for a database home, without actually having access to the database server? In 12.1 Oracle…
Two Occupants That Affect The Most SYSAUX Tablespace Size
Published: Sat, 07/25/20
Is you SYSAUX tablespace running out of space? Are you wondering what is causing the tablespace growth? Normally you would check the the segment with…
How to Install and Patch Oracle in One Line
Published: Fri, 07/17/20
Did you know that at the end of June/beginning of July, Oracle hosted 4 database 19c upgrade webinars? I signed up for them, however the start time of…
3 Things Awesome DBAs Do In The Summer!
Published: Mon, 07/06/20
With summer around the corner, a slower time at work for DBAs comes as well, (and for the IT department in general). If you have some free time on…
The Ultimate SQL Tuning Formula Special Offer!
Published: Mon, 06/29/20
Alright my friend! I promised you a big surprise for today. The Ultimate SQL Tuning Formula is going on sale for CAD 18.97 for a limited time! I’ve…
Things You Might Not Know About the Compression Advisor
Published: Sun, 06/28/20
Last week I received an email from one of my readers, and long time DBA colleague, Wayne, about an interesting thing he encountered, and how he…
Create Indexes When Importing Table With a Different Name
Published: Wed, 06/10/20
Last week we discussed about overcoming the ORA-39034 Table TABLE_DATA: X does not e ist, when importing data with the REMAP_TABLE option. There is…