Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Data loading taking much time from SQL server database to Oracle Database

Sam82Jan 9 2015 — edited Jan 9 2015

Hi,

Oracle DB Version:

Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production

So, I have created a database link that pulls in a table from a SQL server database to Oracle Database. The data volume is big in the sense it is pulling in 15 fields and around 14 milliions rows. It is taking around 3 hours to complete the data load. What I am doing is creating a materialized view which refreshes automatically, simple as below script.

"CREATE MATERIALIZED VIEW TABLE_ORACLE AS SELECT A,B,C FROM TABLE_SQL@DBLINK; "

Is there anything I should research on for it is taking 3 hours for the materialized view to refresh for 14 million rows.

Thanks for the help.

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 6 2015

Added on Jan 9 2015

#general-database-discussions

2 comments

762 views