apps-dba journal

A working journal for Oracle DBAs.

October 27, 2026

Oracle DBA Lesson 88 Part 2 — Move a transport set

A classic transportable-tablespace move combines physical user datafiles with a Data Pump metadata dump . The rows remain in blocks in...

Read the full lesson

October 27, 2026

Oracle DBA Lesson 88 Part 1 — Check the transport set

Transportable tablespaces let a database receive existing data files containing application data, while Data Pump supplies the object m...

Read the full lesson

October 27, 2026

Oracle DBA Lesson 87 Part 2 — Import through a database link

A Data Pump network import reads a source database through a database link and creates the selected objects and data in the target. The...

Read the full lesson

October 27, 2026  · 

Oracle DBA Lesson 87 Part 1 — Copy a schema between explicit PDB services

An application schema can be copied from one pluggable database (PDB) into another with Data Pump. A useful copy needs the intended sou...

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...