Re: Copy a table within a db?

From: Mark Lybarger <MarkLybarger_at_copper.net>
Date: 2000/03/03
Message-ID: <5mJv4.688$wE5.4398@newsfeed.slurp.net>#1/1

does this load the table [MY_TABLE] with all the rows in [SOME_OTHER_TABLE]?

Buck Turgidson <jcmanNOSPAM_at_worldnet.att.net> wrote in message news:Opjv4.4298$NO6.343536_at_bgtnsc06-news.ops.worldnet.att.net...
> When you say copy, do you mean:
>
> CREATE TABLE MY_TABLE
> AS SELECT *
> FROM SOME_OTHER_TABLE
> /
>
>
>
>
>
> <nmadson_at_my-deja.com> wrote in message news:89kce7$gpr$1_at_nnrp1.deja.com...
> > Is there any way to copy a table within a database other than creating
> > a new table and then doing an INSERT INTO {}SELECT query?
> >
> > [I haven't gotten this far in my Oracle Basics class, but I would like
> > to do this now :)]
> >
> > TIA,
> > Nolan Madson
> >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
>
>
Received on Fri Mar 03 2000 - 00:00:00 CST