Re: way to move a table to a new tablespace?

From: Dave Bottom <brooktrout_at_ctel.net>
Date: 2000/08/03
Message-ID: <iDci5.699$P2.13844@harpo>#1/1

Create a temp table in the new tablespace. Copy the contents of the original table into the new/temp table. Drop the original table - it might be a good idea to have exported the table contents just in case something goes wrong. rename the new/temp table to the orignal table name

done

dave

"Ian Warshak" <iwarshak_at_tamu.edu> wrote in message news:soi9h1fcdbm85_at_corp.supernews.com...
> this sounds simple, but i have looked everywhere and cant figure out how
to
> move a table to a new tablespace. i'd appreciate some advice if you all
dont
> mind..
>
>
> also - i have used mysql and there is a command to change databases, which
i
> think is roughly equivalent to changin tablespaces. is there a way that i
> can effectively change my current tablespace to a different to so i can
work
> on some different tables without having to reference them by
> tablespace.table? (say for example i have tables in 2 tablespaces)
>
> thanks again
> ian
>
>
>
Received on Thu Aug 03 2000 - 00:00:00 CDT