RE: transporting 3 TBs of data to a new database

When you setup streams, it can "initialize" the tables, meaning the tables will be created and all the existing data will be copied over.

However, if the data is not changing (no dml against the data) then streams is overkill for your situation.

Regards,

Vlado Barun, M.Sc.
Senior Database Architect
Jewelry Television
Mobile: 865 335 7652
Email: vlado.barun_at_jtv.com
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Dba DBA Sent: Tuesday, September 30, 2008 4:26 PM To: oracle-l_at_freelists.org
Subject: 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<mailto: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<mailto:vlado.barun_at_jtv.com> -----Original Message-----
From: oracle-l-bounce_at_freelists.org<mailto:oracle-l-bounce_at_freelists.org> [mailto: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<mailto:oracledbaquestions_at_gmail.com> Cc: oracle-l_at_freelists.org<mailto: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