thanks for the inputs sir davey23uk.... i am still new with Oracle DBA so i usually use exp/imp for big tables... but it seems that using SQL hints is also faster...


Quote Originally Posted by davey23uk
why do it the slow way?

its within the same database so that will always be slower than insert /*+append*/ into ...