This content has been marked as final. Show 4 replies
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 ).
yes, there is a network link
one time load
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.