Re: transporting 3 TBs of data to a new database

From: Martin Klier <>
Date: Tue, 30 Sep 2008 17:00:15 +0200
Message-ID: <>


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

Received on Tue Sep 30 2008 - 10:00:15 CDT

Original text of this message