Release Notes

17 Migrating an Oracle Database to Dell EMC SC Series Storage | CML1001
3.6.2 Determine the database endian format
To determine the endianness of the source 11gR2 or 12c database, the following query can be executed
against dynamic views V$TRANSPORTABLE_PLATFORM and V$DATABASE in both databases.
Query the endian format of a database
SQL> col platform_name format a36
select tp.platform_name, tp.endian_format from
v$transportable_platform tp, v$database d where
tp.platform_name = d.platform_name;
PLATFORM_NAME ENDIAN_FORMAT
------------------------------------ --------------
Linux x86 64-bit Little
Show all Oracle-supported platforms and their endian formats
SQL> col platform_name format a36
SQL> set pages 50
select platform_name, endian_format from v$transportable_platform
order by platform_name;
PLATFORM_NAME ENDIAN_FORMAT
------------------------------------ --------------
AIX-Based Systems (64-bit) Big
Apple Mac OS Big
Apple Mac OS (x86-64) Little
HP IA Open VMS Little
HP Open VMS Little
HP Tru64 UNIX Little
HP-UX (64-bit) Big
HP-UX IA (64-bit) Big
IBM Power Based Linux Big
IBM zSeries Based Linux Big
Linux IA (32-bit) Little
Linux IA (64-bit) Little
Linux x86 64-bit Little
Microsoft Windows IA (32-bit) Little
Microsoft Windows IA (64-bit) Little
Microsoft Windows x86 64-bit Little
Solaris Operating System (x86) Little
Solaris Operating System (x86-64) Little
Solaris[tm] OE (32-bit) Big
Solaris[tm] OE (64-bit) Big
20 rows selected.