Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Move table to another schema
And don't forget the COPY command.
COPY FROM user_at_datebase TO other_at_database CREATE foo USING select * from schema1.bar;
(lots of ways to do this one!)
Ed
Henrik Blixt <blixt_at_skip.informatik.gu.se> wrote in message news:<3C4D89C0.E6F7154D_at_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 - 12:34:27 CST