1) i have a table with data in india oracle DB.
2) i have a table without data in USA oracle DB.
3) i want to move the table data from india DB to USA DB( update the Datas into USA DB).
how to do it.
Log onto the database in the US and type each and every character exactly the same into insert statements using SQL*Plus.
... Seriously ... no version numbers ... are they the same? How about the character sets ... are they the same?
How much data?
What data types?
Is there a network link between the two? How fast (what speed)?
One time only or on an ongoing basis and if so what delay or close to real-time?
We would like to help you but we can not do so now based on the lack of information you posted.
both the tables have the same structure in both India & US DB.
table in the US DB is empty.
table in the India DB has 8000 records.
now i have to move these 8000 records from India DB(sql server) to US DB ( oracle ).
Links from oracle to sql can be a bit fiddly (unless you are running oracle on windows). It's probably easier to build a DTS/SSIS package in sql server and push the data to oracle that way.