Re: Moving tables to a new tablespace?

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Fri, 22 Nov 2002 16:32:52 +1000
Message-ID: <d6jD9.81551$g9.229890@newsfeeds.bigpond.com>

"Paul Brewer" <paul_at_paul.brewers.org.uk> wrote in message news:3ddd3dbc_2_at_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

Hi Paul,

You need a holiday.

A really long one ;)

Richard Received on Fri Nov 22 2002 - 00:32:52 CST