-
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
-
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.
Tarry Singh
I'm a JOLE(JavaOracleLinuxEnthusiast)
--- Everything was meant to be---
-
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
-
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
-
Thanks Pando..
I think I type bit slow.. by that time you sent me reply...
Thanks
Sameer
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|