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

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s