-- the table from we will move data
create table t_from (
id int,
name char( 30 )
)@

-- the table to we will move data
create table t_to (
id int,
name char( 30 )
)@

-- insert sample data
insert into t_from values
( 1 ,'aaaaa'),
( 2 ,'bbbbb')
@

-- check what we have
select * from t_from@
select * from t_to@

----------------------------------------------------
-- the next statement moves rows from t_from to t_to
-- it uses select from delete
-- and select from insert
-- and returns number of moved rows
----------------------------------------------------
with
   tf as (select * from old table (delete from t_from where id between  1  and  5000 )),
   tt as (select id,name from new table (insert into t_to (id,name) select id,name from tf))
select count(*) from tt
@

-- check the result
select * from t_from@
select * from t_to@

rollback@