DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Assm

  1. #1
    Join Date
    Nov 2000
    Posts
    440

    Assm

    I created some tablespace in oracle 9.2.0.1.0.

    But the segment_space_management was set to manual. Tought is was default auto in 9i. Guess it is like localy manage tablespace in 8i.

    Anyways. Is there a way to alter the tablespace to put it to segment space management auto instead of manual?

    like alter tablespace or alter datafile?

    I dont know the exact syntax if there is a way.

    if there is now way to modify.
    Then i will create a tablespace. Set it to auto.
    And execute alter table move command.
    Is that the fastest way ?

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    nope you cannot convert you have to make a new tablespace

  3. #3
    Join Date
    Nov 2000
    Posts
    440
    Thanks for the info.

    I also notice that the tablespace system is set to manual.

    Can the tablespace system be set to auto also?

  4. #4
    Join Date
    Nov 2000
    Posts
    440
    is there a package that convert a tablespace to assm??

    Or i have to do a script that do alter table move??

  5. #5
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    no you cant convert, you need to create a new one (as said above) and then move objects

  6. #6
    Join Date
    Jul 2002
    Posts
    335
    Originally posted by steeve123
    Thanks for the info.

    Can the tablespace system be set to auto also?
    yes the system tablespace can be made as an assm tablespace, but this has to be done at database creation.

    Bazza

  7. #7
    Join Date
    Jan 2003
    Location
    Delhi
    Posts
    63
    pls refer recent discussion on assm

    http://www.dbasupport.com/forums/sho...threadid=47387

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