I assume realtable is part of a database.
To keep the attributes and references of the real table at runtime, I would not replace it.
May be:
select realtable
zap
append from temptable
works for you.

If you don't care about references and attributes of the realtable
select * from temptable into table realtable data abc
may work either.