Try with following

CREATE global temporary TABLE sam as select * from emp
on commit preserve rows

Kancha