Copy data between two remote databases

copy from     user1/@server1 -
to                   user2/@server2 -
insert         moc_gross_dotsoft -
using         select 'AP'             CIRCLE_NAME, -
        Decode(Initcap(ssa_name),'Rajahmundry','East Godavari', -
        'Vijayawada','Krishna',Initcap(ssa_name))     SSA_NAME, -
        substr(month_year,4)     YEAR, -
        substr(month_year,1,3)     MONTH, -
        ll_during_month_um     MC1_DELS_PROVIDED_URBAN, -
        ll_during_month_rm     MC1_DELS_PROVIDED_RURAL, -
        LL_DISC_DURING_MONTH_UM MC1_DELS_REMOVED_URBAN, -
        LL_DISC_DURING_MONTH_RM MC1_DELS_REMOVED_RURAL, -
        FX_DURING_MONTH_UM     MC1_WLL_FWT_PROVIDED_URBAN     , -  
        FX_DURING_MONTH_RM     MC1_WLL_FWT_PROVIDED_RURAL     ,  -  
        FX_DISC_DURING_MONTH_UM MC1_WLL_FWT_REMOVED_URBAN      , -
        FX_DISC_DURING_MONTH_RM MC1_WLL_FWT_REMOVED_RURAL      , -
        MB_DURING_MONTH_UM     MC1_WLL_MOBILE_PROVIDED_URBAN  ,  - 
        MB_DURING_MONTH_RM     MC1_WLL_MOBILE_PROVIDED_RURAL  , -  
        MB_DISC_DURING_MONTH_UM MC1_WLL_MOBILE_REMOVED_URBAN   , -
        MB_DISC_DURING_MONTH_RM MC1_WLL_MOBILE_REMOVED_RURAL - 
        from     Dotsoft_moc_details -
        where     MONTH_YEAR= -
        (select to_char(last_day(add_months(sysdate,-1)),'MONYYYY')from dual);