copy 명령을 쓰시면 됩니다.

구문은 ...

COPY FROM <db> TO <db> <opt> <table> {(<cols>)} USING <sel> 

구문 설명

<db>    : database string, e.g., scott/tiger@d:chicago-mktg 

<opt>   : ONE of the keywords:  APPEND, CREATE, INSERT, or REPLACE 

<table> : name of the destination table 

<cols>  : a comma-separated list of destination column aliases 

<sel>   : any valid SQL SELECT statement 

예) SQL> copy from scott/tiger@t1 to scott/tiger@t2

INSERT X_TABLE (COL_A, COL_B)

USING SELECT COL_A, COL_B FROM X_TABLE