Oracle DBA

Transportable Tablespaces (TTS) is a powerful Oracle feature that allows you to move entire tablespaces (or sets of tablespaces) between databases by physically copying datafiles plus minimal metadata, instead of unloading and reloading all the data. Because you’re moving data files rather than rows, TTS operations can be vastly faster than conventional export/import. In this […]

Oracle Data Pump (expdp / impdp) is the go-to tool for logical exports and imports. With Oracle Database 19c, Data Pump got several new enhancements to improve flexibility, performance, and security. These changes are especially useful in cloud migrations, partitioned environments, and multi-tenant databases. In this article, we’ll go through each enhancement, explain what it […]