||Oracle Replication Tips by Burleson
completed. Any changes and the data at the two sites will be out of
Export, Import Method
The tried and true method is to export the data at the base site,
move it across the network, and import it at the remote site. This
method was about the only thing available before Oracle9i. By
piping the export to a compression program, the dump file can be
reduced to speed the movement across the network. The most time
consuming part is, of course, the import. Oracle9i introduced a new
method called Transportable Tablespaces.
Transportable tablespaces allow the DBA to export only the
tablespace metadata from the data dictionary and then move the data
in datafiles to the remote site. Once the metadata is loaded into
the remote site’s data dictionary, the tablespace can be used.
Since there is no import of data (except a small amount of
metadata), transportable tablespaces can greatly speed the process
of propagating the initial data to remote master sites.
This is an
excerpt from Oracle Replication By Rampant TechPress (only $19.95).
You can click here to order a copy and get instant access to the code
Get a Personal Oracle
The author is now offering personal mentors for
Oracle DBAs where you can have an Oracle expert right at your
fingertips, anytime day or night. We work with hundreds of Oracle
databases every year, so we know exactly how to quickly assist you
with any Oracle replication question.
You can get me personally, or any Oracle Certified replication DBA
with more than 20 years of full-time IT experience.