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

Oracle DBA Lesson 90 Part 1 — Query a server-side CSV with an external table

Map a text file to typed SQL columns, inspect the resulting rows, distinguish parsing failures from business-rule failures, and explain...

Read the full lesson

Oracle DBA Lesson 89 Part 2 — Incremental transport and the write outage

A supported incremental transport workflow moves most physical data before the write outage, preserves the recovery chain, and reaches ...

Read the full lesson

Oracle DBA Lesson 89 Part 1 — Platform and endian compatibility

Before transporting physical datafiles, identify both database platforms and choose a supported transport method. Endian format is the...

Read the full lesson