Re: Migrating to from dictionary to Locally managed tablespaces

Vincento Harris wrote:

> I am trying to migrate from dictionary managed to locally managed
> tablespaces.
> to be able to use uniform extents using IMP/EXP .
> 1)Any drawbacks.....

To using locally managed tablespace? None. To migrating to locally managed tablespace? Possibly. Depends on how you propose to do the 'migrating'.

>
> My understanding is that
>
> 1)The initial and next extents which I am trying to change will not be
> changed.
> as the imp will define initial and next as they existed in last
> table.

Import will be saying 'create table BLAH with initial 100K next 567K'. The tablespace, which uses (shall we say) uniform 64K extents will turn around to the create table statement and say, 'you can't have 100K. But I can give you two 64K extents, which is close enough'.

Initial is not ignored by locally managed tablespaces, therefore. It is honoured in its intention, at least. You ask for 623K, you'll get 10 64K extents.

Next, however, is completely ignored. Ask for 567K for the table's next extent, and it is given 64K (or, of course, whatever extent size you decided on for your tablespace).

>
> Is there a better way to do this, I have a couple of thousand tables
> and about 70 tablespaces supplied with APP. Oracle 8.1.7.4 HP Unix
> 9000
>

Is there a better way to do what???

Regards
HJR  
> Vince
Received on Thu Oct 02 2003 - 15:21:59 CDT