(Fahd Mirza Chughtai) DevOps is natural evolution for Oracle database administrators or sysadmins of any kind. The key to remain relevant in the industry is to embrace DevOps these days and in near future.
Tag: Oracle
Event incident
(mgogala) In a recent thread on oracle-l, Mikhail Velikikh has pointed me to an interesting but scarcely documented Oracle feature.
DBMS_PDB.DESCRIBE – Something to be aware of
(Mike.Dietrich) When I wrote up my long blog post series about how to migrate to Multitenant, I came across an interesting behavior. I could create the XML manifest file to plugin without putting the database in read-only mode.
Exchange Partition of *-List and *-Range Partition
(Jagruti Jasleniya) 1.Exchange Partition of *-List Partition
A new use for DML error logging
(Connor McDonald) Many moons ago I did a short video on the DML error logging feature in Oracle. The feature has been around for many years now, and is a great tool for capturing errors during a large load without losing all of the rows that successfully loaded. You can watch that video below if you
Customising APEX Validation Message
(Scott Wesley) I’m an advocate for forum participation. This very post was a result of me learning something small just by watching the forums every morning.
Exchanging a Partition of an Interval Partitioned Table
(Jagruti Jasleniya) Let’s create Interval-Partitioned table and exchange partitions.
Basic Replication — 9 : BUILD DEFERRED
(Hemant K Chitale) A Materialized View can be created with all the target rows pre-inserted (and subsequently refreshed for changes). This is the default behaviour.
DDL invalidates your SQL right ?
(Connor McDonald) I stumbled upon this post by optimizer guru Nigel Bayliss last week, so please have a read of that first before proceeding. But I wanted to show a simple demo of how management of cursors continues to improve with each version of the database.
Why is it Important to do Research Before Upgrading?
(Liron Amitzi) One of my client is on 12.1 and since the support for 12.1 has ended we started planning the upgrade of this database.