BigFile Tablespaces (BFT)
Prior to Oracle Database 10g, K and M were
used to specify data file sizes. Since 10g introduces larger
file sizes up to 128 Tera bytes using BFTs, the sizes can be
specified using G and T for Gigabytes and Terabytes.
In Oracle Database 10g, transportable
tablespaces can be moved across different supported platforms
like Solaris, Windows, Linux, HP-UX, AIX and HP Tru 64. The
benefits include easy distribution of data from data warehouses
to data marts on smaller and different platforms.
Read-only
tablespaces can be shared
across heterogeneous clusters, and
databases can be
migrated between different platforms by rebuilding
the catalog and transporting other tablespaces. For transporting
tablespaces between different platforms, endian ordering has to
be the same on both platforms. v$transportable_platform
determines if endian formatting is
the same on both
platforms. Refer to Chapter 2
for a brief introduction
SQL> desc
v$transportable_platform
Name
Null? Type
--------------------------------
-------- ----------------------
PLATFORM_ID NUMBER
PLATFORM_NAME
VARCHAR2(101)
ENDIAN_FORMAT
VARCHAR2(14)
