 Oracle
Tips by BurlesonOracle10g New Cross-Platform Transportable Tablespaces
A transportable tablespace allows you to quickly move a subset
of an Oracle database from one Oracle database to another.
However, in the previous release of Oracle server, you can only
move a tablespace across Oracle databases within the same
platform.
Oracle 10g is going one step further by allowing you to move
tablespace across different platforms.
Benefits
One of the major benefits for organizations that hosts Oracle
databases on different platforms is that data can now be moved
between databases quickly, across different platforms. Using the
new cross-platform transportable tablespaces method to move data
is more efficient than the traditional method of export and
import.
Supported Platforms and New Data Dictionary Views
Oracle Database 10g supports nine platforms for transportable
tablespace.
A new data dictionary view, v$transportable_platform, lists all
eleven supported platforms, along with platform ID and endian
format.
|
PLATFORM_ID |
PLATFORM_NAME |
ENDIAN_FORMAT |
|
1 |
Solaris[tm] OE (32-bit) |
Big |
|
2 |
Solaris[tm] OE (64-bit) |
Big |
|
3 |
HP-UX (64-bit) |
Big |
|
4 |
HP-UX IA (64-bit) |
Big |
|
5 |
HP Tru64 UNIX |
Little |
|
6 |
AIX-Based Systems (64-bit) |
Big |
|
7 |
Microsoft Windows NT |
Little |
|
10 |
Linux IA (32-bit) |
Little |
|
11 |
Linux IA (64-bit) |
Little |
Table 3.3 Supported Platforms for Transportable Tablespaces
The v$database data dictionary view also adds two columns,
platform ID and platform name:
SQL> select name, platform_id,platform_name
2 from v$database;
NAME PLATFORM_ID PLATFORM_NAME
------- ----------- -----------------------
GRID 2 Solaris[tm] OE (64-bit) |
