set long 2000
--
copy from sysadm/pwd@alias1 replace TEMP_INDEX -
using select * from TEMP_INDEX;   
--
set long 2000
copy from sysadm/pwd@alias1 insert dept_tbl -
using select * from dept_tbl where deptid in ('0000009954');