Data Migration using Oracle Transportable Tablespace

Procedure to restore or migrate tablespace with the use of transportable tablespace.

There are two ways to moving tablespace/data to target system.
  • Same platform data migration - Move data to same OS or endian, big to big endian or little to little endian operating system
  • Cross platform data migration - Move data from little to big endian or big to little endian
If we are moving tablespace from little to big endian or big to little endian than we have to convert it to target endian platform which has been showed here in step-7.

If we are moving data to same endian platform operating system even to different OS than it's not required to use convert option.

List of operating system with 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 IA (32-bit) Little
8 Microsoft Windows IA (64-bit) Little
9 IBM zSeries Based Linux Big
10 Linux IA (32-bit) Little
11 Linux IA (64-bit) Little
12 Microsoft Windows 64-bit for AMD Little
13 Linux 64-bit for AMD Little
14 HP Open VMS Little
15 Apple Mac OS Big


Now let's see the demo to migrate tablespace. Here we have created "ttest" tablespace to show the demo.


How to calculate IOPS in Exadata ?

When we think to calculate IOPS , it seems very difficult task but it’s very easy to calculate in Exadata Storage. Let’s understand the procedure to calculate IOPS.

Well, first of all, execute the calibrate command on all available cell storage.

We are doing testing on Exadata Database Machine X3-2 1/8th rack. Same procedure can be followed on any configuration of Exadata.

Cell Server 1

CellCLI> calibrate force

Calibration will take a few minutes...
Aggregate random read throughput across all hard disk LUNs: 1521 MBPS
Aggregate random read throughput across all flash disk LUNs: 8048.46 MBPS
Aggregate random read IOs per second (IOPS) across all hard disk LUNs: 2380
Aggregate random read IOs per second (IOPS) across all flash disk LUNs: 113116
Controller read throughput: 1974.08 MBPS