Re: export table data

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.co                                             
             m>                                                       Para 
             Enviado por:              crcbedoy_at_proteccion.com.co          
             oracle-l-bounce_at_f                                          cc 
             reelists.org                                                  
                                                                    Asunto 
                                       Re: export table data               
             01/11/2006 18:22                                              
                                                                           
                                                                           
                Por favor,                                                 
                responda a                                                 
             jkstill_at_gmail.com                                             
                                                                           
                                                                           

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