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 - 05:35:04 CDT
