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

What is an oracle?

657


How do I limit the number of rows returned by an oracle query after ordering?

727


What is an oracle data file?

697


how to handle exceptions in post production

1037


How to run create database statement?

659






What are the different types of database objects?

622


What are the differences between blob and clob in oracle?

665


Can group functions be used in the order by clause in oracle?

659


Please explain joins in oracle?

647


how to clone 9i Database on to 10g Database.

1908


How to write a left outer join with the where clause in oracle?

721


what is difference between sql plus and sql*plus? (not sql and sql plus).

3428


Explain how are indexes update?

699


Why do you use stored procedures and state some of its disadvantages?

664


What is Data Dictionary Cache in Oracle?

757