Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: export table data

Re: export table data

From: LS Cheng <exriscer_at_gmail.com>
Date: Thu, 2 Nov 2006 14:36:32 +0100
Message-ID: <6e9345580611020536m19df45b8y9621c4d8fcf0bfb4@mail.gmail.com>


hi

you can use copy, db link or exp/imp

On 11/2/06, crcbedoy_at_proteccion.com.co <crcbedoy_at_proteccion.com.co> wrote:
>
> Hi,
>
> There are 989 tables which table data I need to replicate in both
> databases
>
> Isabel Bedoya Gómez
> Gestión de Tecnología
> Tel. 2307500 ext: 4077
> [image: Inactive hide details for "LS Cheng" <exriscer_at_gmail.com>]"LS
> Cheng" <exriscer_at_gmail.com>
>
>
>
> *"LS Cheng" <exriscer_at_gmail.com>*
>
> 02/11/2006 08:02
>
>
> Para
>
> crcbedoy_at_proteccion.com.co
> cc
>
> jkstill_at_gmail.com, oracle-l_at_freelists.org
> Asunto
>
> Re: export table data
>
> hi you can use sqlplus copy command
>
>
>
> On 11/2/06, *crcbedoy_at_proteccion.com.co* <crcbedoy_at_proteccion.com.co> <*crcbedoy_at_proteccion.com.co
> * <crcbedoy_at_proteccion.com.co>> wrote:
>
> Hi Jared,
>
>
> I have two different instances, in each of them I have the
> schemas SR1 and SR2, both of them are same, with the same objects, tables,
> indexes, etc. I just need to transfer the table data from the SR1's tables
> to the SR2's tables. How can I do so?
>
> Isabel Bedoya Gómez
> Gestión de Tecnología
> Tel. 2307500 ext: 4077
> "Jared Still" <* jkstill_at_gmail.com* <jkstill_at_gmail.com>>
>
> *"Jared Still" <**jkstill_at_gmail.com* <jkstill_at_gmail.com>*
> >*
> Enviado por: *
> oracle-l-bounce_at_freelists.org
> *<oracle-l-bounce_at_freelists.org>
>
> 01/11/2006
> 18:22
> Por favor,
> responda a*
> **jkstill_at_gmail.com* <jkstill_at_gmail.com>
> Para
> *
> **crcbedoy_at_proteccion.com.co* <crcbedoy_at_proteccion.com.co> cc
> Asunto
>
> Re: export table data
> On 11/1/06, *crcbedoy_at_proteccion.com.co** *<crcbedoy_at_proteccion.com.co>
> <*crcbedoy_at_proteccion.com.co** * <crcbedoy_at_proteccion.com.co>>
> wrote:
>
> I would like to know something, I need
> to export the table data from one instance to another, how can I do so?
>
> You will need to provide more detail.
>
> Do you just want to copy to a new database:
>
> 1) just a few tables
> 2) a schema
> 3) the whole database
>
> How large is the data to be moved?
>
> How will data be moved to the target?:
>
> 1) by Gig ethernet
> 2) by 100Meg ethernet
> 3) by 10Meg ethernet
> 4) T1
> 5) Fractional T1
> 6) DSL
> 7) Flash Drive
> 6) Dial up
>
> You could:
>
> export/import
> replicate with Data Guard
> replicate with Materialized views
> restore a backup
> duplicate with rman
> restore hot backup, rman or file based
>
> other choices I haven't thought of.
>
> --
> Jared Still
> Certifiable Oracle DBA and Part Time Perl Evangelist
>
>
>
>
>


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


graycol.gif ecblank.gif
Received on Thu Nov 02 2006 - 07:36:32 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US