Copy table attributes
From: Barry Roomberg <barry.roomberg_at_compudata.com>
Date: Thu, 14 Jul 94 21:13:00 -0500
Message-ID: <12a.3349.905_at_compudata.com>
Date: Thu, 14 Jul 94 21:13:00 -0500
Message-ID: <12a.3349.905_at_compudata.com>
-> In Oracle the import/export functions would create a table with the
-> same name, or in this case bomb because I am trying to overwrite the
-> old table. Does
Umm, you want to create an EMPTY table with the same fields as another
table, right?
create table new_table as select * from old_table where rownum = 0;