Re: Reorganizing tables (next extents)

From: FlameDance <flamedance_at_gmx.de>
Date: Thu, 29 Apr 2004 09:20:40 +0200
Message-ID: <c6qabs$ctl$01$1@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:

Locally managed tablespaces were introduced in 8.1.5 - will they work with compatibility setting to 8.1.0?
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 Received on Thu Apr 29 2004 - 02:20:40 CDT