Query to Check Big Endian or Little Endian format for your Oracle Database
Login into Oracle database
SQL> select * from v$transportable_platform;
PLATFORM_ID PLATFORM_NAME ENDIAN_FORMAT CON_ID
----------- ----------------------------------------- -------------- ----------
1 Solaris[tm] OE (32-bit) Big 0
2 Solaris[tm] OE (64-bit) Big 0
7 Microsoft Windows IA (32-bit) Little 0
10 Linux IA (32-bit) Little 0
6 AIX-Based Systems (64-bit) Big 0
3 HP-UX (64-bit) Big 0
5 HP Tru64 UNIX Little 0
4 HP-UX IA (64-bit) Big 0
11 Linux IA (64-bit) Little 0
15 HP Open VMS Little 0
8 Microsoft Windows IA (64-bit) Little 0
9 IBM zSeries Based Linux Big 0
13 Linux x86 64-bit Little 0
16 Apple Mac OS Big 0
12 Microsoft Windows x86 64-bit Little 0
17 Solaris Operating System (x86) Little 0
18 IBM Power Based Linux Big 0
19 HP IA Open VMS Little 0
20 Solaris Operating System (x86-64) Little 0
21 Apple Mac OS (x86-64) Little 0
20 rows selected.
SQL>
On Linux - 12c db
====================
SQL> select platform_id from v$database;
PLATFORM_ID
-----------
13
SQL>
SQL> COL "Source" FORM a32
SQL> COL "Compatible Targets" FORM a40
select d.platform_name "Source", t.platform_name "Compatible Targets", endian_format
from v$transportable_platform t, v$database d where t.endian_format = (select endian_format from v$transportable_platform t, v$database d where d.platform_name = t.platform_name)
order by "Compatible Targets"
/SQL> 2 3 4
Source Compatible Targets ENDIAN_FORMAT
-------------------------------- ---------------------------------------- --------------
Linux x86 64-bit Apple Mac OS (x86-64) Little
Linux x86 64-bit HP IA Open VMS Little
Linux x86 64-bit HP Open VMS Little
Linux x86 64-bit HP Tru64 UNIX Little
Linux x86 64-bit Linux IA (32-bit) Little
Linux x86 64-bit Linux IA (64-bit) Little
Linux x86 64-bit Linux x86 64-bit Little
Linux x86 64-bit Microsoft Windows IA (32-bit) Little
Linux x86 64-bit Microsoft Windows IA (64-bit) Little
Linux x86 64-bit Microsoft Windows x86 64-bit Little
Linux x86 64-bit Solaris Operating System (x86) Little
Linux x86 64-bit Solaris Operating System (x86-64) Little
12 rows selected.
SQL>
On Windows - 12c db
====================
SQL> select platform_id from v$database;
PLATFORM_ID
-----------
12
SQL>
SQL>
SQL>
SQL> COL "Source" FORM a32
SQL> COL "Compatible Targets" FORM a40
SQL> select d.platform_name "Source", t.platform_name "Compatible Targets", endian_format
2 from v$transportable_platform t, v$database d where t.endian_format = (select endian_format from v$transportable_platform t, v$database d where d.platform_name = t.platform_name)
3 order by "Compatible Targets"
4 /
Source Compatible Targets ENDIAN_FORMAT
-------------------------------- ---------------------------------------- --------------
Microsoft Windows x86 64-bit Apple Mac OS (x86-64) Little
Microsoft Windows x86 64-bit HP IA Open VMS Little
Microsoft Windows x86 64-bit HP Open VMS Little
Microsoft Windows x86 64-bit HP Tru64 UNIX Little
Microsoft Windows x86 64-bit Linux IA (32-bit) Little
Microsoft Windows x86 64-bit Linux IA (64-bit) Little
Microsoft Windows x86 64-bit Linux x86 64-bit Little
Microsoft Windows x86 64-bit Microsoft Windows IA (32-bit) Little
Microsoft Windows x86 64-bit Microsoft Windows IA (64-bit) Little
Microsoft Windows x86 64-bit Microsoft Windows x86 64-bit Little
Microsoft Windows x86 64-bit Solaris Operating System (x86) Little
Microsoft Windows x86 64-bit Solaris Operating System (x86-64) Little
12 rows selected.
SQL>
No comments:
Post a Comment