Nov 10

Oracle ORDS returns RAW columns as base64 encoding

Those days, I was building a REST API service for retrieving the columns of a checksum table. The table structure was pretty simple: CREATE TABLE "DEMO" ( "PATH" VARCHAR2(500 CHAR), "MD5_HASH" RAW(16) ); INSERT INTO DEMO ( PATH, MD5_HASH ) VALUES ( 'bundle.xml', '70D53BE37073B31347EE42B622EA4A75' ); COMMIT; So, as you can see, very simple table with …

Continue reading

Nov 09

Get current instance URL in APEX using SQL or JS

If you need to retrieve the current APEX server URL using SQL, there are 3 different functions that can help with that. For example, if my current page is: https://example.oracle.com/ords/r/myworkspace/myapp/mypage?session=12345 APEX_PAGE.GET_URL: SELECT APEX_PAGE.GET_URL FROM DUAL; SQL> /ords/r/myworkspace/myapp/mypage?session=12345 APEX_UTIL.HOST_URL: SELECT APEX_UTIL.HOST_URL FROM DUAL; SQL> https://example.oracle.com APEX_MAIL.GET_INSTANCE_URL: SELECT APEX_MAIL.GET_INSTANCE_URL FROM DUAL; SQL> https://example.oracle.com/ords/r/myworkspace/myapp/ If you want to …

Continue reading

Oct 27

ORA-20000: Insufficient privileges to analyze an object in Dictionary Schema

Today, I was trying to apply the database 12.1.0.2 BP 221018 (October 2022). As usual, for all bundle patches, I have to call datapatch utility twice due to some strange errors during the first execution. However, this time the patch apply process was giving me this strange ORA-20000 error: ORA-20000: Insufficient privileges to analyze an …

Continue reading

Jun 07

How to run impdp in ADB when you don't have access to Object Storage or DB Links

There are usually 3 ways for running impdp: loading the dump file from the Oracle Directory, Object Storage, or through database links. Let's say you don't permission to use database links for whatever reason. When you are in ADB world, in an isolated environment, usually we first upload the dump file to the Object Storage …

Continue reading

May 13

Oracle Database Dictionary changelog

Dictionary changelog for all 19c and 21c versions 19c Oracle Database 19.4.0 dictionary changelog Oracle Database 19.5.0 dictionary changelog Oracle Database 19.6.0 dictionary changelog Oracle Database 19.7.0 dictionary changelog Oracle Database 19.8.0 dictionary changelog Oracle Database 19.9.0 dictionary changelog Oracle Database 19.10.0 dictionary changelog Oracle Database 19.11.0 dictionary changelog Oracle Database 19.12.0 dictionary changelog Oracle …

Continue reading