(Pieter Van Puymbroeck) The 19c DML redirection is one of the key features in Active Data Guard 19c. This means that a lot of questions are coming to my e-mail for this one.
Tag: Oracle
Recovering ODA VMs From Lost ACFS Snapshots
(Andy Colvin) This is a continuation of my previous post regarding dropped ACFS snapshots. In this scenario, a user logged in to a virtualized ODA system and deleted the underlying ACFS snapshots for multiple virtual machines on the host.
Virtual Column Partitioning in Oracle
(Jagruti Jasleniya) Oracle 11g came up with concept of Virtual Column which is created with expression. Which does not stores data physically rather it calculates at run time and give us output when we fetch using query.
Basic Replication — 8 : REFRESH_MODE ON COMMIT
(Hemant K Chitale) So far, in previous posts in this series, I have demonstrated Materialized Views that set to REFRESH ON DEMAND.
ORA-14300 partitioning key maps to a partition outside maximum permitted number of partitions and NULLs
(Martin Bach) While researching interval partitioning in Oracle 19c I came across a phenomenon I had already solved a long time ago but then forgot about.
No more stale statistics in 19c
(Connor McDonald) There is an odd contradiction that we all encounter for most databases, especially if they are predominantly used during the business day.
Oracle patches – a patchfiles anatomy
(Martin Berger) In my previous post I explained some basics about IDs of platforms, products and similar and where these patches can be obtained.
Oracle Error Bash f(x)
(Michael McLaughlin) My students always struggle initially with basic Linux skills. I wrote little function for their .bashrc file to help them avoid the frustration.
Read-Only Partitions in Oracle
(Jagruti Jasleniya) Read-Only partitions are of benefits
Batch Loading CSV to a TABLE in Oracle Autonomous Database using AUTOREST API
(Jeff Smith) Signing up for an Autonomous Database is easy. You can have an instance up and running in just a few minutes. And now, you can even have one for FREE.