PL/SQL package SYS.DBMS_BACKUP_RESTORE version 19.03.00.00 in TARGET database is not current after upgrade Mustafa, 2020-04-06 Hi there, Yesterday I upgraded a 19.3 database to 19.6 on Windows 10 Pro and after upgrade Rman starts to give two warnings: PL/SQL package SYS.DBMS_BACKUP_RESTORE version 19.03.00.00 in TARGET database is not current PL/SQL package SYS.DBMS_RCVMAN version 19.03.00.00 in TARGET database is not current this didn’t happen when I… Continue Reading
Oracle 18c New feature Private Temporary Table Mustafa, 2020-03-22 Hello, 18c introduced a new object called Private Temporary Table (I will call it PTT in this post). PTT is just another version of Global Temporary Table(GTT). The data is temporary and will be stored for a time. Data in temporary tables (both PTT and GTT) can be queried by… Continue Reading
EM Express Basic Troubleshooting Mustafa, 2019-06-092019-06-10 After 12c, unfortunately, we lost Enterprise Manager Console but we have pre-installed EM Express now. if you remember EM console you would install it with emca utility with many parameters. EM express save you from this because it is embedded. you just need to set a few things in your… Continue Reading