Transportable Tablespaces (TTS)

There are several different Oracle-provided utilities or packages that a DBA can use with transportable tablespace(s). What TTS brings to an Oracle database is a method of compartmentalizing the physical database objects (tables and index segments) into a moveable entity. Export/import, data pump, DBMS_FILE_TRANSFER, and RMAN can all move a TTS by changing all of the datafile headers associated with the logical entity known as a tablespace.

Since Oracle10g database, a tablespace can be transported to another database with the same or higher database parameter compatibility setting, and the databases can be on the same or different platforms as well.

Segments that are in the system tablespace and any objects owned ...

Get Oracle Database 11g—Underground Advice for Database Administrators now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.