Re: export table data

Do export and then do import with:
fromuser=sr1,touser=sr2,ignore=y.
This will load the content of the tables into the same tables in sr2, while ignoring the fact that that tables already exist. This will NOT delete all existing data in the tables of sr2.

Adar Yechiel
Rechovot, Israel

crcbedoy_at_proteccion.com.co 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?
>
> I
>
>

--
http://www.freelists.org/webpage/oracle-l