Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

Explain an extent?

1048


For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?

1965


How to create a new oracle data file?

969


How to open a cursor variable?

973


How data locks are respected in oracle?

1009


how can we store any pdf file in oracle

2094


What are the differences between date and timestamp in oracle?

972


In oracle there is column command, how will you explain that?

967


When do you get a .pll extension in oracle?

1077


What is SQL access advisor in Oracle?

1136


What is merge statement used for?

968


How to pass a parameter to a cursor in oracle?

1102


What is oracle database client?

974


What are the roles of dba?

1018


What is the difference between sharding and partitioning?

928