FreeLists / oracle-l / Re: export table data

[crcbedoy@xxxxxxxxxxxxxxxxx]

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@xxxxxxxx                                         
             m>                                                       Para
             Enviado por:              crcbedoy@xxxxxxxxxxxxxxxxx      
             oracle-l-bounce@f                                          cc
             reelists.org                                              
                                                                    Asunto
                                       Re: export table data           
             01/11/2006 18:22                                          
                                                                       
                                                                       
                Por favor,                                             
                responda a                                             
             jkstill@xxxxxxxxx                                         
                                                                       
                                                                       




On 11/1/06, 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