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> 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
> [image: Inactive hide details for "Jared Still" <jkstill_at_gmail.com>]"Jared
> Still" <jkstill_at_gmail.com>
>
>
>
> *"Jared Still" <jkstill_at_gmail.com>*
> Enviado por: oracle-l-bounce_at_freelists.org
>
> 01/11/2006 18:22 Por favor, responda a
> jkstill_at_gmail.com
>
>
> Para
>
> 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