Manage Learn to apply best practices and optimize your operations.

How to use Transportable Tablespaces in Oracle to copy files quickly

Oracle expert Brian Peasland explains how Transportable Tablespaces can be used in Oracle when moving data across to a test environment.

We have a 3TB Data Warehouse on Oracle 10g R2 database on IBM AIX 5.2 OS. We are in the stage of rebuilding a new test/disaster recovery (DR) environment which we want to use as DR and test environments. We would like to refresh the full 3TB of data on a regular basis for system testing, as well as set up some kind of DR on the same server. Is there any fast way of shipping 2TB of data across to the test environment? From what I have been reading a RMAN restore would take weeks, and Data Pump would take a long time as well. Any help on this will be much appreciated.
Probably the quickest way is to use Transportable Tablespaces to copy the files from one system to another. The copy can be as quick as simply transferring files from one server to another. Please read this document on Oracle Transportable Tablespaces for more information.

Dig Deeper on Oracle database backup and recovery

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.