Well, the title tells it all.

 

--this will copy only the structure. notice the impossible where clause. 
create table yourTable_new as select * from yourTable where 1=0;

-- this will copy the data
insert into yourTable_new (select * from yourTable_f);

-- this will copy the table structure AND the data. See, no impossible where clause
create table yourTable_new as select * from yourTable;

Yup ! no more. That’s it ! Well…at least a way that I know. The Oracle world is so big…