Reg Tablespace.

[Former Member]

Hi,

When I'm trying to increase the size of the tablespace using

brtools, i'm getting an error message as given below:

"Not enough free space in C:\oracle\NXI\sapdata4\sr3db_2 for total

maximum size of all database files of tablespace PSAPSR3700 located on

this disk volume, missing at least 17068.071 MB "

Though at the OS level we can view 32.5GB of free space.

With Regards,

Suresh.

[Former Member]

Hi

What seems to be a possiblity as per the msg u posted:

Not enough free space in C:\oracle\NXI\sapdata4\sr3db_2 <b>for total

maximum size of all database files</b> of tablespace PSAPSR3700 located on

this disk volume

that the total maximum size which is defined for every datafile is also calculated and then it checks for the total available free space. Try to reduce the maximum data file size and then try to create the datafile for the tablespace.

The total maximum size of all database files of that tablespace is exceeding the disk size. Try reducing the size and max size of the file and check.

Regards

Sumit Jain

[reward with points if the answer is useful]

[Former Member]

Hi

What can be done is instead of C:\oracle\NXI\sapdata4 you can try to put the datafile in some other folder like sapdata3 or sapdata2 that should solve your problem.

You can also try to add a datafile by copying the command from brtools and run it in SQLPLUS that should also work. [recommended to use brtools but at times it helps]

Regards

Sumit

[reward with points if useful]

[Former Member]

Hi,

Using brtools also, I'm not able to increase the tablespace either in C:\oracle\NXI\sapdata4 or C:\oracle\NXI\sapdata3 or C:\oracle\NXI\sapdata2.

Regards,

Suresh.

[Former Member]

Hai suresh,

better you check at the OS level whether c:\ has the freespace or not...

regards,

Gopi

[Former Member]

Hi Gopi,

I've checked at the OS level.There is a free space of 32.5 GB.

Regards,

Suresh.