truncate table asset_transfer_interface copy to mmscde/paic1234@hdfmsprd insert asset_transfer_interface using select * from asset_transfer_interface copy to mmscde/paic1234@hdfmsprd insert mms2_actions using select * from mms2_actions cop
truncate table asset_transfer_interface
copy to mmscde/paic1234@hdfmsprd insert asset_transfer_interface using select * from asset_transfer_interface
copy to mmscde/paic1234@hdfmsprd insert mms2_actions using select * from mms2_actions
copy to mmscde/paic1234@hdfmsprd insert mms2_actions_eoa using select * from mms2_actions_eoa
copy to mmsdata/paic1234@hdfmsprd create mms_material_info_bak using select m.* from mms_material_info m, mms2_actions a where a.material_id = m.material_id
insert into mms_material_info
select b.*, '', '', ''
from mms_material_info_bak b
where not exists (select 1 from mms_material_info m where m.material_id = b.material_id)
copy {from database | to database | from database to database} {append|create|insert|replace} destination_table [(column, column, column, ...)]
using query