A classic transportable-tablespace move combines physical user datafiles with a Data Pump metadata dump . The rows remain in blocks in...
Read the full lessonOctober 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 lessonOctober 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 lessonOctober 27, 2026 · Oracle DBA
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
Subscribe to:
Posts (Atom)
-
By Gowthami | apps-dba.com | Oracle Administration Series A common issue after Oracle Database 19c patching is a Pluggable Database (PDB) o...
-
By Gowthami | apps-dba.com | Oracle Performance Series Oracle Parallel Query (PQ) allows a single SQL statement to be executed by multiple ...
-
By Gowthami | apps-dba.com | Oracle Exadata Series If you work with Oracle Exadata, one of the most transformative features you will encou...
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...