Site icon EasyOraDBA

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;
Exit mobile version