Cross-Platform Migration

Identify the source database platform and endian format before planning a cross-platform move.

SELECT
    platform_name,
    endian_format
FROM v$database
ORDER BY platform_name;

Review platforms supported for cross-platform tablespace transport.

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

Measure datafiles that will participate in the cross-platform migration.

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;

Review tablespace status and contents before selecting the transport set.

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

Review initialization parameters that may affect cross-platform file conversion.

SELECT
    name,
    value
FROM v$parameter
WHERE name IN (
    'db_file_name_convert',
    'log_file_name_convert'
)
ORDER BY name;

Identify invalid objects before migration so post-migration validation has a clear baseline.

SELECT
    owner,
    object_type,
    COUNT(*) AS invalid_count
FROM dba_objects
WHERE status = 'INVALID'
GROUP BY owner, object_type
ORDER BY owner, object_type;