How can I create a copy of an Oracle table without copying the data?

Question

I know the statement:

create table xyz_new as select * from xyz;

Which copies the structure and the data, but what if I just want the structure?

Answer 1

You can use Where clause because it won’t select any rows:

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

Are you interested in learning SQL from the basics! Refer to this video on SQL provided by Intellipaat:

Note: When you are creating a copy of an ORACLE table without copying the data then the things such as: indexes, triggers, sequences, materialized view logs, things that don’t handle partitions and some constraints also won't be copied to the new table from the original table.