Transportable Tablespaces

Review tablespace status, contents and logging before selecting a transport set.

SELECT
    tablespace_name,
    status,
    contents,
    logging
FROM dba_tablespaces
WHERE contents = 'PERMANENT'
ORDER BY tablespace_name;

Identify tablespaces currently placed in READ ONLY mode before transport.

SELECT
    tablespace_name,
    status,
    contents
FROM dba_tablespaces
WHERE status = 'READ ONLY'
ORDER BY tablespace_name;

Review datafiles, sizes and autoextend settings for transport candidate tablespaces.

SELECT
    tablespace_name,
    file_name,
    ROUND(bytes / 1024 / 1024, 2) AS size_mb,
    autoextensible,
    status
FROM dba_data_files
ORDER BY tablespace_name, file_name;

Check whether the selected tablespace set is self-contained before export.

EXEC DBMS_TTS.TRANSPORT_SET_CHECK(
    'TABLESPACE_1,TABLESPACE_2',
    TRUE
);

SELECT *
FROM transport_set_violations;

Review dependency or containment violations reported by the transport set check.

SELECT
    violations
FROM transport_set_violations
ORDER BY violations;

Review supported platforms and endian formats when the transport crosses platforms.

SELECT
    platform_id,
    platform_name,
    endian_format
FROM v$transportable_platform
ORDER BY platform_id;