Yep. Once you have the new tablespaces just move the objects to it with
whatever command is most relevant (depending on your object).
--
HTH. Additions and corrections welcome.
Pete
Author of "Oracle8i: Architecture and Administration Exam Cram"
Now got a life back again that the book is released!
"Controlling developers is like herding cats."
Kevin Loney, Oracle DBA Handbook
"Oh no, it's not. It's much harder than that!"
Bruce Pihlamae, long-term Oracle DBA
"Fred Pierce" <fpierce_at_avialantic.com> wrote in message
news:3BC6DED2.D1284EF0_at_avialantic.com...
>
>
> "Howard J. Rogers" wrote:
> >
> ...
>
> > In 9i, you have the option to add in tablespaces of different block
sizes
> > than the one you started out with, but that probably isn't what you're
> > after.
> >
> > Regards
> > HJR
>
> Do I read correctly that you could then move objects to the new
> tablespaces and drop the old tablespaces with the old block sizes?
>
> fdp
>
> --------------------------------------------
> Fred Pierce (DNRC) Oracle
> Avialantic.com fpierce_at_avialantic.com
> www.avialantic.com
> MAAM WWII Weekend Airshow 2002 - June 7-9
> MAAM Transportation Show 2002 - Sept. 21-22
> www.maam.org/transhow.html
> -------------------------------------------
>
> >
> > "Tuan Dang" <tdang1_at_slb.com> wrote in message
> > news:9q4hsc$m8h$1_at_news.sinet.slb.com...
> > > Hello,
> > >
> > > Does anybody know how to change the oracle parameter db_block_size?
> > >
> > > Thanks,
> > > Tuan
> > >
Received on Fri Oct 12 2001 - 17:24:55 CDT
