Help copy tables between two DB Ora!

[Former Member]

HI,

I have the necessity to copy (and periodically to modernize) the data from 10 tables on a DB Oracle under SAP on an other DB Oracle. How I can make?

Regards.

[stefan_koehler]

Hello Diego,

the easiest way to do this is using the copy command of sqlplus.

http://oraexplorer.blogspot.com/2007/12/sql-plus-copy.html

http://download.oracle.com/docs/cd/B19306_01/server.102/b14357/apb.htm#SQPUG140

Regards

Stefan

[Former Member]

Thanks,

but the tables on the second db must be updated to the day once like can make?