Oracle copy data to another table

Question

In the Oracle, I copy data from a backup to a new table, it doesn't work.

what is the correct syntax ?

Thanks

select CODE, MESSAGE into EXCEPTION_CODES (CODE, MESSAGE)
from Exception_code_tmp

the error is

**SQL Error: ORA-00905: missing keyword
00905. 00000 -  "missing keyword"**

user_10469193 · Answer

create table xyz_new as select * from xyz where 1=0;