April 2021 archive

Apr 30

New DBA_IMMUTABLE_TABLES view, starting on 19.11

If you follow my quarterly dissecting database patches series, you will note that on 19.11 (April-2021 CPU) oracle introduced a new USER/ALL/DBA_IMMUTABLE_TABLES view. This seems to be related with the new blockchain feature, but on 19.10 (the previous RU), oracle have already created USER/ALL/DBA_BLOCKCHAIN_TABLES. In this post I will investigate the differences among them. So, …

Continue reading

Apr 30

Dissecting 210420 BP, PSU, RU and RUR

I am quarterly writing a post dissecting the changes implemented by Oracle CPUs so we can understand better the modifications implemented by Oracle in our Databases. The following patches were analysed: 11.2.0.4 11.2.0.4.210420 DB PSU 11.2.0.4.210420 Exadata Bundle Patch 11.2.0.4.210420 OJVM PSU 12.1.0.2 12.1.0.2.210420 DB PSU 12.1.0.2.210420 Exadata Bundle Patch 12.1.0.2.210420 OJVM PSU 12.2.0.1 12.2.0.1.210420 …

Continue reading

Apr 30

Oracle April 2021 Critical Patch Advisory - PL/SQL detailed changes

Oracle April 2021 Critical Patch Advisory changed objects performed by each database patch. For more details and the catalog, check the main post: Dissecting 210420 BP, PSU, RU and RUR What exactly changed for each? (click to see detailed line changes) 12.1.0.2 SYS.DBA_LOGSTDBY_NOT_UNIQUE - VIEW 12cR1 (BP) SYS.DBA_LOGSTDBY_UNSUPPORTED - VIEW 12cR1 (BP) SYS.DBA_LOGSTDBY_UNSUPPORTED_TABLE - VIEW …

Continue reading

Apr 15

Protected: How to bypass Oracle Blockchain DROP restriction - Method 3

There is no excerpt because this is a protected post.

Apr 15

Protected: How to bypass Oracle Blockchain DROP restriction - Method 2

There is no excerpt because this is a protected post.