DBA – Rodrigo Jorge – Oracle Dicas e Guias
407 FOLLOWERS
Blog About Databases and High Availability.
DBA – Rodrigo Jorge – Oracle Dicas e Guias
5M ago
If you found this blog post, you are probably facing the boring data pump error: "ORA-39405: Oracle Data Pump does not support importing from a source database with TSTZ version X into a target database with TSTZ version Y.". In this blog post, I will show how to bypass this error with just some extra …
The post How to bypass ORA-39405 Oracle Data Pump does not support importing error appeared first on DBA - Rodrigo Jorge - Oracle Tips and Guides ..read more
DBA – Rodrigo Jorge – Oracle Dicas e Guias
6M ago
Hoje, 04 de Abril de 2024, ocorreu o Oracle OCW em São Paulo, no World Trade Center. O evento foi bem legal. Uma versão reduzida do OCW anual que ocorre em Las Vegas, dada a quantidade menor de pessoas. Minha sessão foi sobre "Por que você deveria modernizar o seu BD?" [LRN1010]. O banco de …
The post Evento Oracle OCW em SP - 2024 appeared first on DBA - Rodrigo Jorge - Oracle Tips and Guides ..read more
DBA – Rodrigo Jorge – Oracle Dicas e Guias
6M ago
Hoje, 03 de Abril de 2024, ocorreu o Oracle DevLive em São Paulo, no World Trade Center. O Oracle DevLive é um evento focado em desenvolvedores com ênfase nas formas como os dados e a IA estão mudando nosso setor. Minha sessão foi sobre "Boas práticas de atualização e migração para o Oracle Database 23c" …
The post Evento Oracle DevLive em SP - 2024 appeared first on DBA - Rodrigo Jorge - Oracle Tips and Guides ..read more
DBA – Rodrigo Jorge – Oracle Dicas e Guias
9M ago
Whenever we patch, upgrade, or migrate our database server, it is important to track what changes we have between the source/target release or patch level to track any possible regressions. One of the things I've been struggling with for years is how to track all the changes that happen to database parameters (including the underscores). …
The post How to get all historical changes on default values of Oracle Database parameters appeared first on DBA - Rodrigo Jorge - Oracle Tips and Guides ..read more
DBA – Rodrigo Jorge – Oracle Dicas e Guias
11M ago
Sometimes, I have to debug and troubleshoot something, and I see myself in a position where I need to get the dictionary code of internal Oracle objects, and the most common way to do that is using DBMS_METADATA. Let's say, for example, that I need to get the view SQL code for DBA_USERS we had …
The post How to check the code of the most important Oracle internal objects without having a database appeared first on DBA - Rodrigo Jorge - Oracle Tips and Guides ..read more
DBA – Rodrigo Jorge – Oracle Dicas e Guias
11M ago
In my daily work, sometimes I see myself in a position that I need to get the vision of an Oracle dictionary table for a specific release. Let's say, for example, that I need to get the list of all parameters we had back in 12.1.0.2 with July 2021 patch applied. Or maybe, what if …
The post How get the contents of the most important Oracle internal views without having a database appeared first on DBA - Rodrigo Jorge - Oracle Tips and Guides ..read more
DBA – Rodrigo Jorge – Oracle Dicas e Guias
1y ago
Oracle Database 19.21 RU was just released! As soon as it is available in My Oracle Support to download, we also add it to ORAdiff app: https://oradiff.oracle.com/ So, what is new? You can check yourself by accessing ORAdiff website and comparing each section, but below I will give a summary of the main changes that …
The post What is new in Oracle Database 19.21 RU appeared first on DBA - Rodrigo Jorge - Oracle Tips and Guides ..read more
DBA – Rodrigo Jorge – Oracle Dicas e Guias
1y ago
After 2 intensive weeks, the LAOUC Tour 2023 is over! It was the first tour after the 2019 pandemic and it was great to see all that legion of people interested in Oracle technologies. Over the 7 countries that I've visited during the tour, I gave the 4 sessions above: Secret Features of Oracle Data …
The post LAOUC 2023 Slides appeared first on DBA - Rodrigo Jorge - Oracle Tips and Guides ..read more
DBA – Rodrigo Jorge – Oracle Dicas e Guias
1y ago
I had a requirement in one tool that I was working to find whether a given table column was power of 2. The easiest way to check would be using the LOG(2,y). If the result was an integer, the number would be power of 2. 2^X = Y -> LOG(2,Y)=X And …
The post LOG(x,y) returning wrong results in some cases appeared first on DBA - Rodrigo Jorge - Oracle Tips and Guides ..read more
DBA – Rodrigo Jorge – Oracle Dicas e Guias
2y ago
In ORDS, I was working with a GET PL/SQL Handler and I need to produce an output variable inside a JSON Object. My ORDS version, as of today, is 22.1.6. Example: BEGIN ORDS.DEFINE_TEMPLATE( p_module_name => 'test', p_pattern => 'test', p_priority => 0, p_etag_type => 'HASH', p_etag_query => NULL, p_comments => NULL); ORDS.DEFINE_HANDLER( p_module_name => 'test', …
The post ORDS output variable inside a JSON Object appeared first on DBA - Rodrigo Jorge - Oracle Tips and Guides ..read more