Methods Available to Copy A Table(s) Or Schema
(Doc ID 2508418.1)
Last updated on NOVEMBER 19, 2024
Applies to:
MySQL Server - Version 5.6 and laterInformation in this document applies to any platform.
Goal
To take a copy of a working data-set, eg for use in a QA / DEV environment.
In a scenario where it is desired to take a copy of a working data-set for any reason, often the best approach is to use / restore a recent backup of the database.
Depending on requirements for the copy ( consistent vs inconsistent ) or the load on the DB ( users / concurrent access ) or simply the size potentially being prohibitivly large, there are a number of options available.
Solution
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
| Goal |
| Solution |
| Complete copy and restore ( interim DB ) |
| Transportable tablespace |
| MySQL Dump / Pump or INSERT + SELECT * |
| MEB using transportable tablespaces (TTS) |