"FlameDance" <flamedance_at_gmx.de> wrote in message
news:c6qabs$ctl$01$1_at_news.t-online.com...
> Hi Jim,
>
> Jim Kennedy wrote:
> > "FlameDance" <FlameDance_at_gmx.de> wrote in message
>
> >>I want to reorganize the tables of a database.
> >>
> >>The database is Oracle 8.1.7 (in 8.1.0 compatibility mode).
> >>
> >>ALTER TABLE <name> MOVE TABLESPACE interim ...
> >>
> > Convert to Locally managed tablespaces with auto. No need to muck with
the
> > minimum extent myth.
>
> 2 questions on this:
>
> 1. Locally managed tablespaces were introduced in 8.1.5 - will they work
> with compatibility setting to 8.1.0?
> 2. Are we talking about the same thing? I want to reorganize the tables,
> you suggest a solution to tablespaces. Does it cover table management too?
>
> Anyway, I doubt I'll get permission to change the database that
> drastically. The owners tend to be very cautious when it comes to
> deviations from the setup made by the software vendor.
>
> Stephan
If you don't want LMT's and I understand the owner's concern. But why are
you reorganizing? Most of us have plenty of useful things to do.
Jim
Received on Thu Apr 29 2004 - 19:14:18 CDT
