22 Aug 2006
Definition plus data?
create table newtab as oldtab with data;
Or just the definition?
...with no data;
check the manuals for details...
Dieter
22 Aug 2006
You can also try out this
Create table a as
Which will be the exact replica of your old table.
22 Aug 2006
Sorry
rewritting the syntax
Create table a as old_table_name
sushant
23 Aug 2006
The exact syntax is as below:
create table product_1 as product with data;
You must sign in to leave a comment.

Any Ideas?
Can I just
Create Table 1 as
(Select * from Table 2)