Category: Oracle Database General

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

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

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

On this page, you can find the Oracle Database 19.4.0 dictionary changelog. This is a fully automated process, that basically does a diff on many important sys dictionary objects from this release with the previous one. Please leave in the comments if you think that anything would worth to be included. 19.4.0 vs. 19.3.0 Table …

Continue reading

On this page, you can find the Oracle Database 19.5.0 dictionary changelog. This is a fully automated process, that basically does a diff on many important sys dictionary objects from this release with the previous one. Please leave in the comments if you think that anything would worth to be included. 19.5.0 vs. 19.4.0 Table …

Continue reading