I am currently attempting to transfer a bunch of data from a table in a Sybase database to a table in an oracle database. We are talking a couple hundred thousand records. What would generally be the best practice to do this? Any database software that can help with this? Any suggestions are welcome.
Presumably the data is unloaded in some flat file format, such as CSV or some form of delimited format.
In Oracle, create an EXTERNAL TABLE, which basically maps a flat file to look like a table. The you can simply do a SQL insert
insert into <table> select * from <external table>