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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- oracle10g_impdp工具測試學習_之二_transport_tablespacesOracle
- Time Series DatabasesDatabase
- Oracle Encrypted TablespacesOracle
- Overview of Tablespaces (38)View
- Introduction to Databases and MySQLDatabaseMySql
- Oracle Transporting TablespacesOracle
- oracle bigfile tablespacesOracle
- NoSQL Databases - Origin and FundamentalsSQLDatabase
- How to Move Tablespaces Across Platforms Using Transportable Tablespaces With RMAN [ID 371556.1]ROSPlatform
- Using Multiple Tablespaces (46)
- TRANSPORT TABLESPACE總結
- Databases are hammers; MapReduce is a screwdriver.Database
- Rowids in Non-Oracle DatabasesOracleDatabase
- 2.5 Overview of Tablespaces and Database Files in a CDBViewDatabase
- Temporary tablespaces in RAC ? Oracle databas...Oracle
- Diffrence Between delete and truncatedelete
- length() between oracle and postgresqlOracleSQL
- Relationship between BAPI and RFCAPI
- COMPUTER DATABASES AND ABSTRACTING SERVICES 2Database
- Connections to NOMOUNT/MOUNTED or RESTRICTED Databases FailRESTDatabaseAI
- OPPO A59怎麼樣? OPPO A59評測
- Backing Up Individual Tablespaces with RMAN
- Transporting Tablespaces with Self-ContainedAI
- Step 8: Create Additional Tablespaces (66)
- golang http/transport 程式碼分析GolangHTTP
- mule進階之jdbc transport:JDBC
- 【遷移】表空間transport
- Centaur: A Framework for Hybrid CPU-FPGA DatabasesFrameworkFPGADatabase
- clone oracle 12c pluggable databasesOracleDatabase
- Django Switching Databases on Per-View LevelDjangoDatabaseView
- Move users between domainsAI
- What is the difference between <%, <%=, <%# and -%> in ERB in Rails?AI
- sql語句 between-andSQL
- Some difference between mysql & oracleMySqlOracle
- 查詢日期帶時分秒00:00:00 23:59:59
- OPPO A59外觀評測 OPPO A59好看嗎?
- ORACLE撤銷表空間(Undo Tablespaces)Oracle
- DELETE from DBA_TABLESPACES IN 10Gdelete