Hi All,
I am fairly new to database administration, so please bear with me if this is something that is simple or not achievable at all -
SetUp:
I have an Oracle DB on one dedicated Server, to which I only have a read_only access.
I have a MySQL database setup on a windows server 2008, both are on the company network and accessible to internal employees only.
Problem Statement:
I need to read certain tables from Oracle DB and push the records to MySQL database.
I have a stored procedure which was doing this but from one Oracle Schema to another, which is running fine, now I need to use the same stored procedure but read from one database (Oracle) and write to another database (MySQL), is there a way to do this through the stored procedure, I know I can write a java program to do this, but need to do it through a stored procedure.
Appreciate any help in this regards.