Re: Copying tables ?

I would do:

create table x
UNRECOVERABLE
as select *

    from olduser.x;

Assuming that you are at 7.2 or higher.

John Duska <duska_at_srfs.pitt.edu> wrote in article <33982133.35892BC8_at_srfs.pitt.edu>...
> What's the easiest way to copy an existing table & its data from one
> schema to another?
> thanks
> John
>
Received on Mon Jun 09 1997 - 00:00:00 CDT