configured het services over gateway from oracle 11.2.0.4 to mysql 5.6
Have a table I want to pull over into oracle. 1000 rows.
On mysql : create view vw_mysql_t1 as select columns from my_mysql_table.
On Oracle: create view vw_ora as select columns from vw_mysql_t1@mysql_link
On oracle: select * from vw_ora data returns data in 3-4 seconds.
however, try an insert to get the data over
insert into a_table_on_oracle
(select * from vw_ora)
takes 11-12 minutes.
create table as or insert into same performance. Tried just inserting 1 row and same performance 11-12 minutes. any ideas?