Re: Move table to another schema

From: Henrik Blixt <blixt_at_skip.informatik.gu.se>
Date: Tue, 22 Jan 2002 16:48:16 +0100
Message-ID: <3C4D89C0.E6F7154D@skip.informatik.gu.se>

or use:

create table schema2.foo as (select * from schema1.bar);

/henrik

Syltrem wrote:
>
> AFAIK, the answer is no.
>
> Use EXPort TABLES=xxx, then IMP TABLES=xxx fromuser=origin
> TOUSER=destination
>
> HTH
>
> --
>
> Syltrem
> http://pages.infinit.net/syltrem (OpenVMS related web site - en français)
> To reply to myself directly, remove .spammenot from my address
>
> "Philip Morrow" <cracker_at_mymorrow.com> a écrit dans le message news:
> fne38.411383$oj3.78280200_at_typhoon.tampabay.rr.com...
> > Can you move a table from one schema to another with the alter table
> > command??
> >
> > Thanks
> > Phil
> >
> >
Received on Tue Jan 22 2002 - 09:48:16 CST