Allocation Type

[Sameer]

Hi,

Is it possible to alter Allocation Type from 'USER' to 'SYSTEM' (Auto allocate) for tablespace converted to LOCALLY MANAGED tablespace using DBMS_SPACE_ADMIN

or

do I have to create it again?

Thanks

Sameer

[Tarry]

Which tablespace are you attempting to migrate dmt to lmt,
Is it users or system?
system you won't be able to do in 816, it's possible in 9i.

[pando]

migrating wont make allocation type SYSTEM, it only reduce the overhead of accessing data dictionary but it wont stop fragmentation

you have to recreate it if you want to use every feature in LMT

[Sameer]

SYSTEM - ofcourse not.. at the moment I don't have guts to do so.. :-)

I am trying to migrate USERS tablespace to LMT. When I tried to migrating a small test tablespace .. it got converted to LMT but the allocation type is set as 'USER' as it was before migration. I want to set allocation type to 'SYSTEM', i.e Auto Allocate.

Question is .. Is it possible to change allocation type after migration ?? Because I din't find anything in ALTER TABELSPACE .. allocation type...

Sameer

[Sameer]

Thanks Pando..

I think I type bit slow.. by that time you sent me reply...

Thanks

Sameer