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“.
create table xyz_new as select * from xyz where rownum < 0;
In Oracle SQL Developer
Leave a Reply