Re: transporting 3 TBs of data to a new database

the data is already in the database. i thought streams worked off the redo logs? they would not do us any good.

On Tue, Sep 30, 2008 at 12:50 PM, Barun, Vlado <Vlado.Barun_at_jtv.com> wrote:

> 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_at_jtv.com
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
> On Behalf Of Martin Klier
> Sent: Tuesday, September 30, 2008 11:00 AM
> To: oracledbaquestions_at_gmail.com
> Cc: oracle-l_at_freelists.org
> 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
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l