Images

CHAPTER9

Cross-Platform Transportable Tablespace Migration Utilities

As we demonstrated in Chapter 6, one of the most flexible and effective methods for transporting databases in piecemeal fashion between different OS platforms—especially when the platforms are of different endianness—is the Transportable Tablespace (TTS) feature set. But no matter which TTS method is selected, all of them still have one serious drawback: the need to bring the set of tablespaces to be transported from the source database’s OS platform into READ ONLY mode for an extended period of time—what we have termed the window of inopportunity—until all datafiles for those ...

Get Oracle Database Upgrade, Migration & Transformation Tips & Techniques now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.