expdp command

Hello Folks,

We are running some query for splitting the data from some table and inserting to others table but its taking to much time. So we are now planning to do with expdp command which is quite fast.

below are the query which we are using from sql command which is taking much time

CREATE TABLE CRPDTA.GLMET AS SELECT * FROM CRPDTA.F0911 WHERE GLKCO IN ('00000','00001','00002');

CREATE TABLE CRPDTA.GLDST AS SELECT DISTINCT GLKCO,GLDOC,GLICU FROM CRPDTA.F0911

WHERE GLKCO NOT IN ('00000','00001','00002') AND GLCO IN (''00000','00001','00002'') ORDER BY GLKCO,GLDOC,GLICU