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 <vegiv...@tuxera.be>wrote: > On Fri, Dec 11, 2009 at 1:56 PM, Ken D'Ambrosio <k...@jots.org> 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