Nice cookbook approach of all the necessary steps: http://www.oracle-base.com/Articles/9i/TransportableTablespaces9i.php -- //www.freelists.org/webpage/oracle-l