on 11-05-2013 12:29 PM
Dear Experts,
I cannot do client copy because some the following table spaces are full:
PSAPSR3
PSAPSR3701
PSAPSR3USR
SYSAUX
SYSTEM
I tried to extend them by BRtools , but i receive the following error:
BR1049W Not enough free space in E:\oracle\MI1\sapdata1\sr3_72 for total maximum
size of all database files of tablespace PSAPSR3701 located on this disk volume
missing at least 460517.264 MB
I've juste tried to extend it 1GB and I have 94GB free in E,
Would you please help?
BR,
Salameh
Hi Salamed,
1 -> you have (some of) the datafiles from the tablespace PSAPSR3701 located in E:\oracle\MI1\sapdata1\sr3_72
2 -> some of those datafiles are set to autoextend
3-> if ALL datafiles would grow to the MAXEXTEND size there would be not enough space on the filesystem (missing at least 460517.264 MB)
source : http://scn.sap.com/thread/1878658
hope it makes sense
Best Regards
Marius
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear All,
Thank you so much. You are right it was because of the "autoextend ".
Thanks a lot,
BR,
Salameh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Friends,
I am facing similar error or warning while adding datafile to tablesapce PSAPSR3.
BR1049W Not enough free space in E:\oracle\PM1\sapdata2 for total maximum size of all database files of tablespace PSAPSR3701 located on this disk volume, missing at least 7213.555 MB
BR0280I BRSPACE time stamp: 2015-11-02 19.05.36
BR0668I Warnings or errors occurred - you can continue to ignore them or go back to repeat the last action
BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:
Can you please clarify me how to add a datafile?
There is enough freespace in E drive i.e.,67.4 GB
Kindly help me adding a new datafile.
Best Regards
Satya
Hi,
Are there some table space with Auto extendible settings on if yes it can be the reason you are thing that the space is free but logically it might be not.
Can you please past the screen shot that you are getting while entering space details as it dont thing correct size is entered.
thanks
Rishi abrol
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
BR1049W Not enough free space in E:\oracle\MI1\sapdata1\sr3_72 for total maximum
size of all database files of tablespace PSAPSR3701 located on this disk volume
missing at least 460517.264 MB
This is just a warning. You should be able to continue with by entering C
460517.264 MB is strange as this is almost 450 GB
Check the entries you have made for extending the tablespace or provide the complete log.
What is the version of BRTools ?
Regards
RB
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
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.