From: "Mark Lybarger" <MarkLybarger@copper.net>
Subject: Re: Copy a table within a db?
Date: 2000/03/03
Message-ID: <5mJv4.688$wE5.4398@newsfeed.slurp.net>#1/1
References: <89kce7$gpr$1@nnrp1.deja.com> <Opjv4.4298$NO6.343536@bgtnsc06-news.ops.worldnet.att.net>
X-Priority: 3
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200
X-Trace: newsfeed.slurp.net 952066561 209.41.196.41 (Fri, 03 Mar 2000 00:56:01 CDT)
X-MSMail-Priority: Normal
NNTP-Posting-Date: Fri, 03 Mar 2000 00:56:01 CDT
Newsgroups: comp.databases.oracle.misc


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


Buck Turgidson <jcmanNOSPAM@worldnet.att.net> wrote in message
news:Opjv4.4298$NO6.343536@bgtnsc06-news.ops.worldnet.att.net...
> When you say copy, do you mean:
>
> CREATE TABLE MY_TABLE
> AS SELECT *
> FROM SOME_OTHER_TABLE
> /
>
>
>
>
>
> <nmadson@my-deja.com> wrote in message news:89kce7$gpr$1@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.
>
>