Re: Moving tables to a new tablespace?

From: Paul Brewer <paul_at_paul.brewers.org.uk>
Date: Thu, 21 Nov 2002 20:10:35 -0000
Message-ID: <3ddd3dbc_2@mk-nntp-1.news.uk.worldonline.com>

"Howard J. Rogers" <howardjr2000_at_yahoo.com.au> wrote in message news:nH%C9.80960$g9.228062_at_newsfeeds.bigpond.com...
> Alter table emp move tablespace BLAH;
>
> Schema doesn't even come into it: you can never change the schema of an
> object, unless you export it, drop it, and import it with the
> FROMUSER/TOUSER parameters.
>
> Regards
> HJR
>
> "Tiger Woods" <clintonn_at_meb.co.za> wrote in message
> news:3ddc85a2$0$229_at_hades.is.co.za...
> > Hi all.
> >
> > What is the sytax to move a table to a new tablespace within the same
> > schema?
> >
> > Thanks
> >
> > Clint
> >
> >
>

Can't add to that, except to say that if I played golf half as well, I'd be on the tour, not slaving away as a DBA.

alter ball move tablespace hole;
ORA-1000001: Missed by 1.5 inches
rollback;
rollback complete
Alter system set optimiser_offset North by Northwest degree 2; system altered
alter ball move tablespace hole;
ball altered
commit;
commit complete

Birdie!

Regards,
Paul Received on Thu Nov 21 2002 - 14:10:35 CST