Database Reference
In-Depth Information
Database Requirements for Transportable Tablespaces
To utilize the transportable tablespace feature, you must make sure the database meets
the following criteria:
To create a transportable tablespace set, the source database must be Oracle 8 i or
later, and it must be Enterprise Edition.
To import a tablespace set from the same platform, the target database can be any
edition of Oracle 8 i or higher.
To create a transportable tablespace set for import into a database on a different
platform, the source database must have compatibility set to 10.0 or higher.
To import a transportable tablespace set from a different platform, both the source
and target databases must have compatibility set to 10.0 or higher.
The source and target database must have the same character set and national char-
acter set.
If your source and target are different platforms, it will be necessary to check for endian
compatibility. If the source and target are not directly compatible—for example, the source
is big endian and the target is little endian—then you will need to use RMAN to convert
the copy of each tablespace data file on either the source or target platform. To determine
which platforms you can transport to, run this query:
SQL> select * from v$transportable_platform order by PLATFORM_ID;
PLATFORM_ID PLATFORM_NAME ENDIAN_FORMAT CON_ID
----------- -------------------------------- -------------- --------------
1 Solaris[tm] OE (32-bit) Big 0
2 Solaris[tm] OE (64-bit) Big 0
3 HP-UX (64-bit) Big 0
4 HP-UX IA (64-bit) Big 0
5 HP Tru64 UNIX Little 0
6 AIX-Based Systems (64-bit) Big 0
7 Microsoft Windows IA (32-bit) Little 0
8 Microsoft Windows IA (64-bit) Little 0
9 IBM zSeries Based Linux Big 0
10 Linux IA (32-bit) Little 0
11 Linux IA (64-bit) Little 0
12 Microsoft Windows x86 64-bit Little 0
13 Linux x86 64-bit Little 0
Search WWH ::




Custom Search