Hello all,
I am seek for help from anyone who experience in create a table base on few joins tables which contains million records and has where conditions.

What are the suggestion on this to fasten the table creation process ?

Here is my current situation :
CREATE TABLE EMP
PARALLEL 4
AS SELECT /*+ CHOOSE */ DEPT.a, STORE.b
FROM dept@DBLINK, store@dblink
WHERE a.DEPTID = b.DEPTID;

Note: dept and store tables consists of million records.

Thanks You.