Re: Move table to another schema

From: Syltrem <syltrem_at_videotron.spammenot.ca>
Date: Tue, 22 Jan 2002 09:46:57 -0500
Message-ID: <PVe38.1146$EI.6932@tor-nn1.netcom.ca>

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 - 08:46:57 CST