And if downtime is a concern, you can use streams to minimize to downtime. Regards, Vlado Barun, M.Sc. Senior Database Architect Jewelry Television Mobile: 865 335 7652 Email: vlado.barun@xxxxxxx -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Martin Klier Sent: Tuesday, September 30, 2008 11:00 AM To: oracledbaquestions@xxxxxxxxx Cc: oracle-l@xxxxxxxxxxxxx Subject: Re: transporting 3 TBs of data to a new database Hi, do you have a DB link in between? Or do you want to have the data on disk for transport? Just a hint: If not, use impdp via DB link, works like a charm in late 10.2(.0.4). Dba DBA schrieb: > I am on ASM, the group moving the data is not. I think transportable > tablespaces is the best way to do this. So I have to use RMAN to put the > data in ASM. Is this a copy to an an ASM tablespace? Any idea how > this works? I am trying to figure out how long this will take. We may be > able to do it in pieces. > > I dont think data pump is good for this. > > I also dont know a good wait to write comma delimitted files out of this > much data to sql load. -- Usn's IT Blog for Linux, Oracle, Asterisk http://www.usn-it.de -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l