-
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
Thanx
Sam
Life is a journey, not a destination!
-
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.
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|