on 08-27-2010 12:19 PM
Hi experts,
I have a doubt regarding tablespace extension using brtools.
i am receiving an error even when there is enough space in sapdata filesystems
Not enough free space in /oracle/SID/sapdata4/siddb_5 for total maximum size of all database files of tablespace PSAPSIDDB located on this disk volume.
This tablespace has YES option for auto extend.
Could this be any reason?
Hi,
As the tablespaces are in the auto extend mode, they will be allocated the max size eventhough it is not visible at the OS level. If u turn off the autoextend, u will gain some space at the OS level and hence u will be able to extend the tablespace in that particular SAPDATA directory.
Regards,
Varadharajan M
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
yes,this is exactly the reason.
brspace is telling you that if all datafiles would grow to their max_size, it would overflow disk space.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.