(Connor McDonald) I wrote a blog post called The Death of UTL_FILE which attracted a comment from a reader:
Tag: Oracle
Automatically capture all errors and context in your APEX application
(Dimitri Gielis) Let me start this post with a conversation between an end-user (Sarah) and a developer (Harry):
How to do EXPORT / IMPORT between #Exasol and #Oracle
(Uwe Hesse) The commands IMPORT and EXPORT provide an easy way to transfer data between Exasol and other data sources like an Oracle database. You may at first get this error message: Oracle instant client not available. Please ask your administrator to install it via EXAoperation.
More triggers are better
(Connor McDonald) Yes, you heard me correctly. If you have got one trigger on a table, then you might be surprised to find that perhaps having a second one will be a better option.
Partitioning — 3a : Indexes on a Partitioned Table
(Hemant K Chitale ) Building on the case study of the Range Partitioned Table from the previous Blog Post, here are some Indexes.
RMAN Commands
(mdinh) Note to self to configure and clear settings, and all things RMAN.
Performance Metric Service – Classic Configuration
(Bobby Curtis) Almost a year ago, Oracle released Oracle GoldenGate 12c (12.3.0.1.x). At that time, there were two architectures released; Microservices and Classic. Both architectures provided the same enterprise level replication.
Non-existent Objects (and possibly a bug)
(amitzil) This post is following a question I found on LinkedIn. A DBA pasted a strange test case in 11.2.0.4 and I managed to reproduce it in 12.1.0.2 (non-multitenant) and 12.2 (multitenant).
Working with the APEX tree
(Tobias Arnhold) Out of a coincidence I haven’t used the APEX tree region for years. Now I got the task to create a customizable tree in my application. Since APEX 5 there is a new tree type called “APEX tree” which supports some really cool functions.
DDL for constraints – subtle things
(Connor McDonald) The DBMS_METADATA package is very cool. I remember the days of either hand-crafting DDL statements based on queries to the data dictionary, or many a DBA will be familiar with running “imp show=y” or “imp indexfile=…” in order to then laboriously extract the DDL required from the i
