Create a copy of an Oracle table without copying the data?

Do a "create table" as command without selecting any rows

create table abc_new as select * from abc where 1=0;

One thought on “Create a copy of an Oracle table without copying the data?

Leave a Reply