I have created a materialized view:
create materialized view SELECT_DOCS
build deferred
refresh force on demand
as
select * from test
Pure select * from test works in 10 mins.
When I do "exec DBMS_SNAPSHOT.REFRESH(list => 'SELECT_DOCS',method => 'c', atomic_refresh => false);"
Then it takes much longer time. (At least more than one hour)
Oracle database version: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production