Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Create copy of table

Re: Create copy of table

From: Alexei VORONOV <alexei_voronov_at_yahoo.com>
Date: Sat, 10 Nov 2001 15:58:59 +0100
Message-ID: <9sjf89$21n$1@wanadoo.fr>


Attention, the default values for the columns in the old table will be lost!

"ejmcgovern3" <ejmcgovern3_at_home.com> a écrit dans le message news: AXaH7.64512$SF4.2282531_at_news1.rdc1.sdca.home.com...
> create table NEWTABLENAME as select * from OLDTABLENAME nologging;
>
>
> "Mike" <michael_p_at_blueyonder.co.uk> wrote in message
> news:A%9H7.20018$mh1.2499073_at_news1.cableinet.net...
> > How do I create a new table NEW_TABLE and copy into it all the contents
of
> > OLD_TABLE without typing out all the column names?
> >
> >
> >
> > Mike
> >
> >
>
>
Received on Sat Nov 10 2001 - 08:58:59 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US