Re: Moving 10g database between platforms

From: Mark D Powell <Mark.Powell2_at_hp.com>
Date: Mon, 1 Feb 2010 05:18:17 -0800 (PST)
Message-ID: <b52ff780-698a-4175-b27e-dd500b54dcb3_at_r19g2000yqb.googlegroups.com>

On Jan 31, 10:55 pm, vsevolod afanassiev <vsevolod.afanass..._at_gmail.com> wrote:
> 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?

When you use the transportable tablespace option you first create the target database: system, sysaxu, undo, and temp and then import the user object tablespaces of interest. (Would also mean new control files and spfile)

10g did not introduce transportable tablesapces as this feature existed in previous versions. What it introduced is the ability to perform endian conversion and move the tablespace dataset across platforms. See v$transportable_platform.

HTH -- Mark D Powell -- Received on Mon Feb 01 2010 - 07:18:17 CST