Re: export table data
- From: Yechiel Adar <adar666@xxxxxxxxxxxx>
- Date: Thu, 02 Nov 2006 18:50:05 +0200
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@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?
I
--
//www.freelists.org/webpage/oracle-l
Other related posts:
