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

create table xyz_new as select * from xyz where rownum < 0;

In Oracle SQL Developer

  • use the menu-function (maybe right-click) on the table you want to operate on (i.e. that you want to copy),
  • Table“,
  • Copy…“,
  • w/o checking “Include Data“.

This site uses Akismet to reduce spam. Learn how your comment data is processed.