Oracle Database 10 GB-table space that can be transferred

In Oracle Database 10 Gb, this restriction disappears: as long as the operating system has the same byte order, you can transmit tablespaces between platforms. This article will not expand the length of the byte sequence

In the Oracle Database 10 Gb, this restriction disappears: as long as the operating system has the same byte order, you can transmit tablespaces between platforms. This article will not expand the length of the byte sequence

The portable tablespace can now be migrated across platforms, making data publishing faster and easier. In addition, external table downloads make data transfer tasks easier and faster through conversion.

How do you migrate data from one database to another? One of the existing methods is particularly good: the tablespace can be transferred. In this method, you use a set of self-contained and read-only tablespaces to export only metadata, and copy the data files of these tablespaces to the target platform at the operating system layer, import metadata into the data dictionary-this process is called insert.

SQL> select * from v $ transportable_platform order by platform_id; PLATFORM_ID PLATFORM_NAMEENDIAN_FORMAT ----------- platform -------------- 1 Solaris [tm] OE (32-bit) Big2 Solaris [tm] OE (64-bit) big3 HP-UX (64-bit) Big4 HP-UX IA (64-bit) Big5 HP Tru64 UNIXLittle6 AIX-Based Systems (64-bit) Big7 Microsoft Windows IA (32-bit) little8 Microsoft Windows IA (64-bit) Little9 IBM zSeries Based LinuxBig10 Linux IA (32-bit) Little11 Linux IA (64-bit) little12 Microsoft Windows 64-bit for AMD Little13 Linux 64-bit for AMDLittle15 HP Open VMSLittle16 Apple Mac OSBig Assume that you want to transmit a tablespace USERS to the computer TGT1 running the Microsoft Windows operating system from a host SRC1 running the Linux operating system on the Intel architecture. Both the source and target platforms are low-address and Low-byte-order. The data file of the tablespace USERS is users_01.dbf. Follow these steps.

Make the tablespace read-only: alter tablespace users read only;

Export the tablespace. Run the following command at the operating system prompt: exp tablespaces = users transport_tablespace = y file = exp_ts_users.dmpexp_ts_users.dmp file only contains metadata (not the USERS tablespace), so it will be very small.

Copy the exp_ts_users.dmp and users_01.dbf files to the host TGT1. If you use FTP, You need to specify the binary option.

Insert the tablespace into the database. Run the following statement at the operating system command prompt: imp tablespaces = users transport_tablespace = y file = exp_ts_users.dmp datafiles = 'users _ 01. dbf'