How to Migrate Large Amount of Binary XML Data between Databases
(Doc ID 2309649.1)
Last updated on FEBRUARY 06, 2024
Applies to:
Oracle Database Cloud Schema Service - Version N/A and laterOracle Database Backup Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Oracle Database - Enterprise Edition - Version 11.2.0.1.0 to 12.2.0.1 [Release 11.2 to 12.2]
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Information in this document applies to any platform.
Purpose
The purpose of this note is to detail recommended methods to move a Large Amount of Binary XML Data between Databases. Please contact support for guidance on this note if additional help is required.
The note is intended for all Oracle users and developers using the Binary XMLType datatype.
The feature Transport Tablespace Operations for binary XML has limited support in 11.2.0.3, 11.2.0.4, 12.1.0.1 and 12.1.0.2 versions of source database. Starting with 12.2.0.1 version as source, TTS should work albeit at time it will go through re-encoding.
Details
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Purpose |
| Details |
| My database is too big to move using conventional datapump, What are the possible options to move Binary XML Data? |
| Short Description of problem |
| Solution provided by these scripts |
| Access to the Script |
| Contacts |
| References |