Please HELP me its urgent? If i want to EXPORT data from
SQL server to ORACLE 11g then how can I replicate data from
SQL to ORACLE?

Answer Posted / abdul

Another Option would be do a bcp out for sql server data to
csv file, then do a sql loader script to insert into Oracle
from csv file.by this way you can even preserve timestamp

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to compare dates in oracle sql?

659


Explain what are the uses of rollback segment?

590


What will be the syntax to find current date and time in format "yyyy-mm-dd"?

570


What are the tools for Oracle ?

613


How to create an initialization parameter file?

543






What query tells you how much space a tablespace named test is taking up, and how much space is remaining?

1812


Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

1812


How to create a temporary table in oracle?

694


What is archive log in Oracle?

605


How to run create database statement?

579


Difference between the “verify” and “feedback” command?

775


What is Segment Advisor in Oracle?

674


How to use existing values in update statements using oracle?

548


Explain what are the different type of segments?

580


What is a snapshot log?

564