Transportable Tablespace for Source and Target

— Save file as .sql and run from sql*plus

TTITLE ‘Current Transportable Tablespace Platform Attributes’
COL platform_name   FORMAT A40      HEADING ‘Platform Name’
COL endian_format   FORMAT A12      HEADING ‘ENDIAN|Format’

—–

— What are the available Transportable Tablespace Platform possibilities?
—–
SELECT
platform_name
,endian_format
FROM v$transportable_platform
ORDER BY platform_name
;

TTITLE OFF

TTITLE ‘Current Database Platform ENDIAN-Ness’
COL name            FORMAT A16      HEADING ‘Database Name’
COL endian_format   FORMAT A12      HEADING ‘ENDIAN|Format’

—–
— What’s the current ENDIAN-ness of my database and platform?
—–

SELECT
D.name
,TP.endian_format
FROM
v$transportable_platform TP
,v$database D
WHERE TP.platform_name = D.platform_name
;

TTITLE OFF


Leave a Reply