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

Thread: alter tablespace

  1. #1
    Join Date
    Oct 2000
    Posts
    22

    Wink

    Does the syntax "ALTER TABLESPACE" lock the tablespace just as "ALTER TABLE" locks the table does?

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Yes it would the lock would be a very short lived one, to even notice in the production...

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  3. #3
    Join Date
    Oct 2000
    Posts
    211
    Sam,
    I have a doubt. When adding datafiles, does 'alter tablespace' lock the entire tablespace? What if there are inserts going on into other datafiles which are already existing in that tablespace? Do the inserts stop, till the new datafile gets built?
    In my case it takes almost 2.50 minutes for adding a datafile, but I have not noticed if the inserts stop during the alter tablespace.Can you please clarify?
    Thanks
    manjunath

  4. #4
    Join Date
    Apr 2001
    Location
    Brisbane, Queensland, Australia
    Posts
    1,203
    I'm pretty sure the insert keep occuring. I've added numberous datafile to my system on the fly, meaning three 4 gb files at a time. And the inserts keep occuring.
    OCP 8i, 9i DBA
    Brisbane Australia

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