Re: export table data

  • From: "Sergey Popov" <sspopov@xxxxxxxxx>
  • To: crcbedoy@xxxxxxxxxxxxxxxxx
  • Date: Thu, 2 Nov 2006 12:22:08 -0500

The correct way to transfer the data depend on many other things:

consistency requirements
referencial constraints
network channel
presence of LONG columns
data volume
DB version
disk storage availability (to store a dump file)
and other things like sequences that may need to be adjusted

Possible solutions may include:

emp/imp
empdp/impdp
SQL*Plus copy
truncate/insert via DB link



Sergey


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

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 11-2006