Re: Moving tables...

From: TurkBear <johng_at_mm.com>
Date: Wed, 22 Sep 1999 14:21:26 GMT
Message-ID: <37e8e4fa.1956763@super.news-ituk.to>

Well maybe...it depends on what you mean by dropping/recreating... If ther are not a lot of constraints/foreign keys, etc involved, you can do the following....

use
create table new_table_temp_name tablespace new_space as select * from old_table

Drop old_table

rename new_table_temp_name old_table_name..

Now this is a form of dropping/recreating but without having to 'actually' create the new table specs...

jonathan_at_gennick.com (Jonathan Gennick) wrote:

>Unfortunately, the answer is no.
>
>On 20 Sep 99 19:47:42 GMT, holdampf_at_mkb.hu (Zoltan Holdampf)
>wrote:
>
>>I'd like to know, is there any way to move a table from its tablespace
>>to another without dropping and recreating it?

-----------== Posted via Newsfeeds.Com, Uncensored Usenet News ==---------- http://www.newsfeeds.com The Largest Usenet Servers in the World! ------== Over 73,000 Newsgroups - Including Dedicated Binaries Servers ==----- Received on Wed Sep 22 1999 - 09:21:26 CDT