David, Transportable tablespace is on my second test list. I need to pull data from 6 tables and insert into 3 tables. So I will need staging tables on both source and target databases. My concern is the unneeded logging that will occur on both the source and target database while inserting data in the staging tables. We are using dataguard with forced logging, so we can not use nologging feature while inserting in the staging tables. Thanks Sandeep -- //www.freelists.org/webpage/oracle-l