Re: export table data

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


                                                                       
             "LS Cheng"                                                
             <exriscer@xxxxxxx                                         
             om>                                                      Para
                                       crcbedoy@xxxxxxxxxxxxxxxxx      
             02/11/2006 08:02                                           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> 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
      Inactive hide details for "Jared Still" <jkstill@xxxxxxxxx>"Jared
      Still" < jkstill@xxxxxxxxx>

                                                                       
                         "Jared Still"                                 
                         <                                             
                         jkstill@gmail                                 
                         .com>                                         
                         Enviado por:                                 Para
                         oracle-l-boun                                 
                         ce@freelists.               crcbedoy@xxxxxxxxxxxx
                         org                         om.co             
                                                                       
                                                                        cc
                         01/11/2006                                    
                         18:22                                         
                                                                    Asunto
                                                                       
         Por favor, responda a                       Re: export table data
           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



GIF image

GIF image

GIF image

Other related posts: