Arup Nanda On Transporting Warehouse Data
September 22, 2004
Mark Rittman

OTN are currently running a good article by Arup Nanda, on the ways of transporting warehouse data using Oracle 10g. Entitled "Moving Data Faster", it takes the form of a case study and looks at Data Pump, transportable tablespaces, and something referred to as "pulling tablespaces". So what's "pulling tablespaces" about? According to the article:

"As a third option, Lora suggests using a new tool in Oracle Database 10g that simplifies the transportable tablespace approach so that it involves only the execution of a single packaged procedure. In this approach, the user "pulls" the tablespaces from the source system, using a supplied package, DBMS_STREAMS_TABLESPACE_ADM. This package uses Data Pump to transport tablespaces and transfers the data files to the target system's format. It also performs any required endian conversion automatically."

Interesting stuff. The article's got examples of the DBMS_STREAMS_TABLESPACE_ADM package in use, together with more details on transportable tablespaces and Data Pump, and can be found over on OTN.