Re: Renme Tablespace in 8i

oeps - 7.3 .... then it'll be the hard way - but if you're migrating to 8i you might as well do an export/import and put everything in place ....
oh BTW - an alter table move doesn't work with tables containing long and raw columns - also recreate/rebuild your indexes after a move.
If you some money to throw with you can also check out Quest Spacemanager or Quest Live Reorg. The first one
costs about 15000$ to 20000$ (for a typical 4way unix box) - the Live Reorg will cost you a heck of a lot more ...
Maybe you should consider migrating to Oracle 9i - it also let you 'live reorg' your tables....

cheers

"Linda Tuner" <LindaTuner_at_hotmail.com> wrote in message news:s7Bv7.57863$0x.21738810_at_typhoon.southeast.rr.com...
> Thanks, Mr. Sybrand. I misspoke, I meant to say that we are migrating
> to 8i from 7.3, so this is really a 7.3 question. We are told that
> the only way is to recreate the objects in the other tablespace. Is
> that true?
>
>
>
> "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message
> news:trtmo3ljapr538_at_news.demon.nl...
> >
> > "Linda Tuner" <LindaTuner_at_hotmail.com> wrote in message
> > news:ZkAv7.57575$0x.21711673_at_typhoon.southeast.rr.com...
> > > We have a vendor database that "prefers" that certain objects be
> in
> > > certain tablespaces. The manual was not RTF'd and now we have the
> > > objects in the wrong TS. Is it possible to rename a tablespace in
> 8i,
> > > or do we have to do it the hard way?
> > >
> > >
> >
> > The hard way?!:
> > alter table <table_name> move <new_tablespace>
> > provided the compatible parameter is at least 8.1.0 and not 8.0.5
> > (which is the default for 8i)
> >
> > Regards,
> >
> > Sybrand Bakker Bakker, Senior Oracle DBA
> >
> >
> >
>
>
Received on Sat Oct 06 2001 - 06:39:50 CDT