Moving 10g database between platforms

From: vsevolod afanassiev <vsevolod.afanassiev_at_gmail.com>
Date: Sun, 31 Jan 2010 19:55:58 -0800 (PST)
Message-ID: <55d9fb50-c096-4409-9cc2-1d100ea93990_at_a16g2000pre.googlegroups.com>

In 10g Oracle introduced ability to use transportable tablespaces to move
data between different platforms if endian format is the same:

PLATFORM_ID PLATFORM_NAME                  ENDIAN_FORMAT
----------- ------------------------------ --------------
          1 Solaris[tm] OE (32-bit)        Big
          2 Solaris[tm] OE (64-bit)        Big
          7 Microsoft Windows IA (32-bit)  Little
         10 Linux IA (32-bit)              Little
          6 AIX-Based Systems (64-bit)     Big
          3 HP-UX (64-bit)                 Big
          5 HP Tru64 UNIX                  Little
          4 HP-UX IA (64-bit)              Big
         11 Linux IA (64-bit)              Little
         15 HP Open VMS                    Little
          8 Microsoft Windows IA (64-bit)  Little
          9 IBM zSeries Based Linux        Big
         13 Linux x86 64-bit               Little
         16 Apple Mac OS                   Big
         12 Microsoft Windows x86 64-bit   Little
         17 Solaris Operating System (x86) Little
         18 IBM Power Based Linux          Big
         20 Solaris Operating System (x86- Little
            64)

         19 HP IA Open VMS                 Little

So it should be possible to use transportable tablespaces to move data from
Sun SPARC Solaris to AIX.

Question: is it possible to copy entire database including control files,
redo logs, SYSTEM and SYSAUX tablespaces? Received on Sun Jan 31 2010 - 21:55:58 CST