Re: Copy a table within a db?

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 Thu Mar 02 2000 - 00:00:00 CST