| Transportable tablespace via network link utility [message #690342] |
Sat, 26 April 2025 12:42 |
 |
Olexandr Siroklyn
Messages: 43
Registered: September 2018
Location: USA
|
Member |
|
|
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:
1. Provided by Oracle xttdriver.pl utility. Good luck to you to overpass all complications of that utility.
2. Via 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 them on your own, 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. It can be downloaded from https://oracleongpu.com/ttsworks/
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 also means destination OS can be only an OS where dialog is available. Standard edition is not supported. The TTSWorks utility doesn’t process any possible run-time errors. If error comes it’s your choice how to manage it.
Features
Restoring data files in parallel mode is not possible via a network link. This limitation is overcome in the 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.
License
The TTSWorks utility is a free software. You can do with the utility whatever you want.
Screenshot
[Updated on: Sat, 26 April 2025 12:56] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
