Oracle Undo and Deleting Many Rows

Lets consider a hypothetical use case: – Limited Undo usage: either by disk space, or undo quota – Large table with many rows to remove/update. There are different ways to handle this situation and your particulars may vary. Considerations may include: Creating a new table with just the rows desired, using parallel DML, etc.¬†Ask Tom […]

Executing host commands from an Oracle database

Several times during my career, I have encountered the need or the question of how to run operating systems commands from the Oracle Database. Doing research on the topic – there are two main ways to accomplish this task. Java or DBMS_SCHEDULER Java Once Oracle included JAVA in the database (v8 + review the version […]