+ Reply to Thread
Results 1 to 4 of 4
  1. 09-05-2001 09:51 AM #1
    thedba
    thedba is offline Junior Member
    Join Date
    Oct 2000
    Posts
    22

    Wink

    Does the syntax "ALTER TABLESPACE" lock the tablespace just as "ALTER TABLE" locks the table does?
    Reply With Quote Reply With Quote
  2. 09-05-2001 11:42 AM #2
    sambavan
    sambavan is offline Senior Advisor
    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!

    Reply With Quote Reply With Quote
  3. 09-05-2001 12:09 PM #3
    manjunathk
    manjunathk is offline Member
    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
    Reply With Quote Reply With Quote
  4. 09-05-2001 06:46 PM #4
    grjohnson's Avatar
    grjohnson
    grjohnson is offline Senior Advisor
    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
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Bookmarks

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