Oracle DBA Lesson 93 Part 1 — Make an administrative script fail safely

An administrative script needs a reliable failure path. SQL*Plus normally continues after an SQL error. A later successful exit can the...

Read the full lesson

Oracle DBA Lesson 92 Part 1 — Change a maintenance window with a backout

Choose maintenance time from measured workload demand, edit a Scheduler window, preserve the original configuration, and check the next...

Read the full lesson

Oracle DBA Lesson 91 Part 1 — Inspect maintenance clients and windows

Identify the maintenance clients and their eligibility, inspect their configured windows, and compare actual runs with a batch interval...

Read the full lesson

Oracle DBA Lesson 90 Part 2 — Unload selected rows with ORACLE_DATAPUMP

Write the result of a SQL query into a binary external-table file, query that file again, and explain when a schema export is needed to...

Read the full lesson