FreeLists / oracle-l / Re: export table data

["LS Cheng" <exriscer@xxxxxxxxx>]

hi

you can use copy, db link or exp/imp



On 11/2/06, crcbedoy@xxxxxxxxxxxxxxxxx <crcbedoy@xxxxxxxxxxxxxxxxx> 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@xxxxxxxxx>]"LS
> Cheng" <exriscer@xxxxxxxxx>
>
>
>
>     *"LS Cheng" <exriscer@xxxxxxxxx>*
>
>             02/11/2006 08:02
>
>
> Para
>
> crcbedoy@xxxxxxxxxxxxxxxxx
> cc
>
> jkstill@xxxxxxxxx, oracle-l@xxxxxxxxxxxxx
> Asunto
>
> Re: export table data
>
> hi you can use sqlplus copy command
>
>
>
> On 11/2/06, *crcbedoy@xxxxxxxxxxxxxxxxx* <crcbedoy@xxxxxxxxxxxxxxxxx> 
> <*crcbedoy@xxxxxxxxxxxxxxxxx
> * <crcbedoy@xxxxxxxxxxxxxxxxx>> 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@xxxxxxxxx* <jkstill@xxxxxxxxx>>
>
>            *"Jared Still" <**jkstill@xxxxxxxxx* <jkstill@xxxxxxxxx>*
>                               >*
>                               Enviado por: *
>                               oracle-l-bounce@xxxxxxxxxxxxx
>                               *<oracle-l-bounce@xxxxxxxxxxxxx>
>
>                               01/11/2006
>                               18:22
>                                   Por favor,
>       responda a*
>       **jkstill@xxxxxxxxx* <jkstill@xxxxxxxxx>
>         Para
>       *
>       **crcbedoy@xxxxxxxxxxxxxxxxx* <crcbedoy@xxxxxxxxxxxxxxxxx> cc
>       Asunto
>
>       Re: export table data
>       On 11/1/06, *crcbedoy@xxxxxxxxxxxxxxxxx** *<crcbedoy@xxxxxxxxxxxxxxxxx>
>       <*crcbedoy@xxxxxxxxxxxxxxxxx** * <crcbedoy@xxxxxxxxxxxxxxxxx>>
>       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