Does the syntax "ALTER TABLESPACE" lock the tablespace just as "ALTER TABLE" locks the table does?
Printable View
Does the syntax "ALTER TABLESPACE" lock the tablespace just as "ALTER TABLE" locks the table does?
Yes it would the lock would be a very short lived one, to even notice in the production...
Sam
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
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.