Allocation Type
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Allocation Type

  1. #1
    Join Date
    Sep 2001
    Location
    Düsseldorf, Germany.
    Posts
    588
    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

  2. #2
    Join Date
    Jan 2002
    Location
    Netherlands
    Posts
    1,587
    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)
    TarryBlogging
    --- Everything was meant to be---

  3. #3
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    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

  4. #4
    Join Date
    Sep 2001
    Location
    Düsseldorf, Germany.
    Posts
    588
    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

  5. #5
    Join Date
    Sep 2001
    Location
    Düsseldorf, Germany.
    Posts
    588
    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
  •  


Click Here to Expand Forum to Full Width