-
When a datafile in a tablespace is runing out of space, we can either add another datafile to that tablespace or RESIZE / AUTOEXTEND the datafile.
What is better RESIZE or AUTOEXTEND?
Personally, I feel AUTOEXTEND is better as RESIZE would increase the size of the file unnecessarily (may be). The impact this has is that backup size of the files are larger.
Any other issues to be considered?
Any other views on this?
Thanks.
With regards.
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
|