Can you use that syntax if the databases are on different file systems? If
you can, and the original table is big, the command would take a while as it
moved data from one file system to another.
On Fri, Dec 11, 2009 at 7:58 AM, Johan De Meersman <vegivamp@stripped>wrote:
> On Fri, Dec 11, 2009 at 1:56 PM, Ken D'Ambrosio <ken@stripped> wrote:
>
> > > rename table oldschema.table to newschema.table;
> >
> > Just to be 100% clear -- I assume you have to first create the
> destination
> > database, and then do this for all the tables in the source database?
> >
>
> Yep. Easily scriptable, though :-)
>
--
Jim Lyons
Web developer / Database administrator
http://www.weblyons.com
