Milliseconds are lost after date to tz conversion on 19c Mustafa, 2025-07-15 Hi, yesterday, I found (maybe) a small bug in 19c. Whenever I deal with timestamp with time zones, I always learn something new. so, the request is as this: there is a DATE column which should be converted into a timestamp with tz but if it is null then result… Continue Reading
DDL Generation Failed with ORA-65047: Object SYS.KUPUTIL is invalid Mustafa, 2025-06-19 Hello everyone, recently I copied a PDB into another CDB and after all the actions are done, developers got error during ddl generation: ORA-65047: Object SYS.KUPUTIL is invalid or compiled with errors in root. ORA-06508: PL/SQL: could not find program unit being called: "SYS.KUPUTIL" ORA-06512: at "SYS.KUPU$UTILITIES_INT", line 1730 ORA-06512: at "SYS.DBMS_METADATA", line 1216 ORA-06512: at "SYS.DBMS_METADATA", line 8546 ORA-06512: at line 1 123456 ORA-65047: Object SYS.KUPUTIL is invalid or compiled with errors in root.ORA-06508: PL/SQL: could not find program unit being called: "SYS.KUPUTIL"ORA-06512: at "SYS.KUPU$UTILITIES_INT", line 1730ORA-06512: at "SYS.DBMS_METADATA", line 1216ORA-06512: at "SYS.DBMS_METADATA", line 8546ORA-06512: at line 1 This is basically because and invalid synonym “KUPUTIL”. to overcome the issue, I recreate the synonym and compile invalid objects one by one. it must be… Continue Reading
How to call HTTPS Url Without SSL Wallet in 19c Mustafa, 2025-04-06 Hi, as you know for over the years, if you want to call a secure url (https) you must add the certificates to your ssl wallet first. this operation, most probably, requires also DBA action. Finally with 23ai changed this and now you can call a https url without wallet…. Continue Reading
Is Table Unnecessary for Pipelined Function Mustafa, 2025-04-05 Hello everyone, What a busy year. I couldn’t find time to write something and so much is happening, AI models, Quantum etc. So I want to write more now. I know that many people think that blogging is dead but I don’t share this thought because AI is still not… Continue Reading
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