Oracle DBA

XTTS (Cross-Platform Transportable Tablespaces) is used to migrate large Oracle databases between different platforms while minimizing downtime.It combines three technologies: The idea is: Below is the full operational procedure used in real migrations. Step 1 — Verify Platform Compatibility Identify the source and target platform endian format. SELECT platform_name, endian_formatFROM v$transportable_platformORDER BY platform_name; Confirm the […]

Transportable Tablespaces (TTS) is a powerful Oracle migration technique used to move large datasets quickly by transporting datafiles instead of exporting rows. The migration mainly uses: Below is the complete step-by-step process, where the RMAN conversion step is included when required. Step 1 — Check Platform Compatibility First determine whether the source and target platforms […]