(Jan Kettenis) In this article I describe how to return a HTTP 404 (resource) Not Found with a REST integration that on its turn calls another REST service that returns a 404.
Tag: Oracle
Statistics on Load
(Connor McDonald) One of the talks I gave recently on the Groundbreaker Yatra tour was on the changes that arrive with the optimizer when you move to 12c and above.
Truncate Partition Operation
(Jagruti Jasleniya) Just like we do truncate operation on table , we can truncate partition too.
Basic Replication — 6 : COMPLETE and ATOMIC_REFRESH
(Hemant K Chitale) Till 9i, if you did a COMPLETE Refresh of a Single Materialized View, Oracle would do a TRUNCATE followed by an INSERT.
Oracle 19c Automatic Indexing: Configuration (All I Need)
(Richard Foote) In this post, I’ll discuss how to configure the new Automatic Indexing capability introduced in Oracle Database 19c.
OIC: Handling Optional Elements in a REST Integration
(Jan Kettenis) This article is a follow-up of the a previous article where I discuss how to handle optional elements in case of XML in the Oracle Integration Cloud (OIC). In the following I discuss how to create an integration that invokes VBCS REST service and works in (almost) the same way as the
Foreign Keys and Multi-Table Inserts in Oracle
(David Fitzjarrell) An interesting issue reared its head back in version 9.2 of Oracle and, unfortunately, has not been corrected.
sqlldr, direct path loads and concurrency in 12.2 and later
(Martin Bach) In my previous post I showed you that Oracle’s SQL loader (sqlldr) utility has a built-in timeout of 30 seconds waiting for locked resources before returning SQL*Loader-951/ORA-604/ORA-54 errors and failing to load data.
Coalesce Partition and Subpartition
(Jagruti Jasleniya) As we saw in previous posts by just defining number of partitions we can create partitions in HASH partition or *-hash subpartitions paritioning type.
Oracle EBS 12.2 on-prem is now certified with Oracle 19c – and will become a PDB
(Mike.Dietrich) Great news – and I’m just putting the pieces together. Oracle EBS 12.2 on-prem is now certified with Oracle 19c.