Dijkgraaf - 9:35 pm on Mar 13, 2012 (gmt 0)
First you probably want to establish a ODBC Gateway between MYSQL and the Oracle DB.
This will allow you to select from MySQL and insert into Oracle in one SQL statement.
You can then have a cron job execute MySQL statements.
(Search on the bolded phrases if you need to find more details).
You will then either want a flag or a inserted/date time on your MySQl database table so you can select the records that you want to insert into Oracle. My preference would be a flag as the date/time method would involve date comparisons to the last run of the script.