Preamble
Have you ever migrated a user schema from big-endian to little-endian, or vice versa? Small schema migrations can be performed using the standard Oracle database utilities, expdp/impdp. But what about migrating terabytes of data? expdp/impdp is a wrong choice because it is a very time-consuming process. What other options are there? Using Golden Gate is possible if you have the budget for it and enough time for preliminary works. Is there any thing else with low cost and low time consuming? Sure there is a transportable tablespace way. As a matter of fact there are two variants of the transportable tablespace way:
- Provided by Oracle xttdriver.pl utility. Good luck to you to overpass all complications of that utility.
- A network link way described in a *document 12.2 RMAN Cross Platform Tablespace Transport Over Network (Doc ID 2307383.1)
Note: the * document only describes how to transfer tablespaces. What about non-tablespace schema objects? You will need to take care of these yourself, or you can use a TTSWorks utility. The TTSWorks utility has been created to provide a way N2 and overcome all additional difficulties in terms of time decreasing.
Details
The TTSWorks utility is written in shell script and SQL language. As you can see from below text user interface (TUI) is provided and it’s made via Linux-always-available dialog utility. That’s also means data migration is available from Solaris, AIX and HP-UX to Linux only.
Features
- Restoring data files in parallel mode is not possible via a network link. This limitation is overcome in the TTSWorks utility.
- To speed up statistics transfer it’s made via statistics collection download into a table with a help of DBMS_STATS.EXPORT_SCHEMA_STATS function.
- Incremental restore of data files is available.
Initial settings
There is a file .envtts for that. It must be adjusted.
License
The TTSWorks utility is a free software. You can do with it whatever you want.
Download
Screenshots
