cancel
Showing results for 
Search instead for 
Did you mean: 

extend tablespace, error: Not enough free space in...

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

former_member206552
Active Contributor
0 Kudos

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

Answers (3)

Answers (3)

Former Member
0 Kudos

Dear All,

Thank you so much. You are right it was because of the "autoextend ".

Thanks a lot,

BR,

Salameh

Former Member
0 Kudos

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

Former Member
0 Kudos

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

Reagan
Advisor
Advisor
0 Kudos

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