Transport of Tablespaces Between Databases (59)
A transportable tablespace lets you move a subset of an Oracle database from one
Oracle database to another, even across different platforms. You can clone a tablespace
and plug it into another database, copying the tablespace between databases, or you
can unplug a tablespace from one Oracle database and plug it into another Oracle
database, moving the tablespace between databases.
Moving data by transporting tablespaces can be orders of magnitude faster than either
export/import or unload/load of the same data, because transporting a tablespace
involves only copying datafiles and integrating the tablespace metadata. When you
transport tablespaces you can also move index data, so you do not have to rebuild the
indexes after importing or loading the table data.
You can transport tablespaces across platforms. (Many, but not all, platforms are
supported for cross-platform tablespace transport.) This can be used for the following:
■ Provide an easier and more efficient means for content providers to publish
structured data and distribute it to customers running Oracle on a different
platform
■ Simplify the distribution of data from a data warehouse environment to data
marts which are often running on smaller platforms
■ Enable the sharing of read only tablespaces across a heterogeneous cluster
■ Allow a database to be migrated from one platform to another
資料庫間傳輸表空間
可傳輸表空間 :一個Oracle資料庫的子集嵌入 ,遷移 , 複製至另外一個資料庫 ,即使是在不同的表平臺上.
相比於匯入匯出/裝載資料 , 透過傳輸表空間來遷移資料的速度是數量級的 , 因為他只涉及到複製資料檔案和
整合表空間後設資料 , 在傳輸表空間時 , 也可以遷移索引並且不用重建
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/10599713/viewspace-976746/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Time Series DatabasesDatabase
- 2.5 Overview of Tablespaces and Database Files in a CDBViewDatabase
- COMPUTER DATABASES AND ABSTRACTING SERVICES 2Database
- COMP4039 DIS Databases InterfacesDatabase
- Centaur: A Framework for Hybrid CPU-FPGA DatabasesFrameworkFPGADatabase
- HDU 1385 Minimum Transport Cost
- 59
- What is the difference between a Homemaker and a Housewife?
- How to review diffs between commitsViewMIT
- Difference between cursor and a ref cursor
- golang http/transport 程式碼分析GolangHTTP
- SAP Retail Differences Between Articles and MaterialsAI
- 1344. Angle Between Hands of a Clock
- Oracle DG管理Redo Transport服務Oracle
- innodb_undo_tablespaces導致Mysql啟動報錯MySql
- Oracle 12.2 How to Generate AWRs in Active Data Guard Standby DatabasesOracleDatabase
- 淺談mysql中各種表空間(tablespaces)的概念MySql
- Between validator常用驗證規則
- 查詢日期帶時分秒00:00:00 23:59:59
- In-depth analysis of the comparison between AT and XA of distributed transactions
- MySQL中BETWEEN子句的用法詳解MySql
- [20180812]TRANSPORT_CONNECT_TIMEOUT and RETRY_COUNT.txt
- 【OCP最新題庫解析(052)--題8】Which two are true about undo tablespaces?
- [LeetCode] 1385. Find the Distance Value Between Two ArraysLeetCode
- 【Oracle SQL】months_between與trunc函式OracleSQL函式
- [leetcode] 1624. Largest Substring Between Two Equal CharactersLeetCode
- ISO C++ forbids comparison between pointer and integer [-fpermissive]C++ORB
- Difference Between Arraylist And Vector : Core Java Interview Collection QuestionJavaView
- Transport Layer Security for UDP&TCP(TLS/DTLS1.2)UDPTCPTLS
- elastic學習-elastic stack 基礎安全(transport層)AST
- 7 Redo Transport Services 日誌傳輸服務
- Oracle 12C RMAN Cross-Platform Transport of PDBsOracleROSPlatform
- PostgreSQL DBA(59) - Index(Bloom)SQLIndexOOM
- 59. Spiral Matrix II
- [AlwaysOn2017] AlwaysOn的DMV和DMF -sys.availability_databases_clusterAIDatabase
- Jayson Tatum is a fascinating player who has a sort of in-between kind
- ERROR: failed to establish dependency between database db_name and diskgroupErrorAIDatabase
- Oracle 12c RMAN Cross-Platform Transport of a Closed PDBOracleROSPlatform
- 每週分享第 59 期