Full Transportable Export/Import – PAR File Examples

Roy and I blogged about Full Transportable Export/Import in the past: Full Transportable Export/Import White Paper Full Transportable Export/Import – Things to Know Full Transportable Export/Import – Migrating an 11.2.0.4 database to Oracle Database 12c- into the Oracle Cloud Exclude Stats differently for TTS and FTEX If you haven’t heard of this database feature, it allows you to migrate a full database by using Transportable Tablespaces as a base technology but letting Data Pump do all the manual steps for you in a one-command migration. And if needed, it works with RMAN Incremental Backups as well in order to decrease…

How to find out if a PSU has been applied? DBMS_QOPATCH

Since we change the PSU and BP patch numbering from Oracle Database 12.1.0.2.PSU6 to 12,1,0,2,160119 it is almost impossible to distinguish from the patch name only if you have applied a PSU or a BP. But: In Oracle Database 12c there’s a package available which is very useful to query plenty of information about patches from within the database: DBMS_QOPATCH. Here are a few helpful examples which I created by checking in our DBaaS Cloud database. Which patches have been applied (or rolled back)? SQL> set serverout on SQL> exec dbms_qopatch.get_sqlpatch_status; Patch Id : 20415564 Action : APPLY Action Time :…