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"** 

Answer 1

You need an INSERT ... SELECT

INSERT INTO exception_codes( code, message )   SELECT code, message     FROM exception_code_tmp 

Answer 2

If you want to create table with data . First create the table :

create table new_table as ( select * from old_table);  

and then insert

insert into new_table ( select * from old_table); 

If you want to create table without data . You can use :

create table new_table as ( select * from old_table where 1=0);