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@xxxxxxxxx>]"Jared
Still" <jkstill@xxxxxxxxx>
*"Jared Still" <jkstill@xxxxxxxxx>*
Enviado por: oracle-l-bounce@xxxxxxxxxxxxx
01/11/2006 18:22 Por favor, responda a
jkstill@xxxxxxxxx
Para
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
