Be careful on Standard Edition 2 CPU Licensing Mustafa, 2020-04-222020-04-22 Hi, Today I looked for some dedicated servers for two of my customers. They have Standard Edition 2 (SE2) License. So this license says you can have only 1 CPU socket on the machine it does not matter how many core it has! this is really great reason to use… Continue Reading
Oracle Enterprise Manager Express 19c missing menus Mustafa, 2020-04-08 Hello again, Today, I’ve read a thread in the community and OP was asking for missing menus like Configuration, Storage, Tablespaces, users etc. This is the default behavior now! Since flash become obsolete slowly, Oracle leaves old EM Express flash version and comes up with Java Jet and default is… Continue Reading
How to convert a LONG column to CLOB directly in a query Mustafa, 2020-04-062020-04-06 Hi, This is a big problem since LONG is a very painful data type. You cannot search in it, use it in CTAS (create table as), pass it to a plsql object as parameter etc. Oracle strongly suggest not to use a LONG column anymore but unfortunately there are many… 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