Re: changing the tablespace for a table

"Todd Marshall" <toddm_at_semaphore.com> wrote:

The user does not matter after table creation as far as tablespace usage goes - Create the table in the new tablespace using the 'create new_table as select * from old_table tablespace new_space' construct and grant the user access to the new_table - then drop the old_table( using synonyms to then recreate the old_table's name and access rights )

Hope it helps...

John.Greco_at_dot.state.mn.us

>Hi all-
> I need to move a table from one tablespace to another (same user). I
>can't for the life of me find any docs for doing this without
>changing users, which I don't want to do if I don't have to . Any ideas?
>
>-Todd
>
Received on Fri May 30 1997 - 00:00:00 CDT