table space 300 MB only

[Former Member]

Hi all,

We have situation where our free table space is only 300 MB.. so when we try to delete something from BI production data warehouse it get dumps.

So can any body suggest wat can be done to resolve this issue and how space can be frreed ?

We cannot extend table space..

thanks a lot in advancce

[Former Member · Accepted solution]

Thaks,

We solved the problem by deleting the table rsberrorlog from production server.

it gives the enough space to work ahead.

thanks

[rajesh_kumar71]

Hi ,

If the issue is resolved kindly close the message.

regards,

S.Rajeshkumar

[rajesh_kumar71]

Hi ,

Free table space is 300mb - if this was the case increasing table space will solve by increase the table space , ensure the data base growth , and if the existing data file reaches the max.limit then go for the option - adding a data file .

I assume the DB was Oracle , check the table space using BR tools .Kindly provide your DB name and version .

SQL> select file_name from dba_data_files where tablespace_name = '<tablespace_name>';

Datafile names for the tablespace <tablespace_name> will be displayed.

SQL> alter tablespace <tablespace_name> add datafile '/oracle/<SID>/<sapdata directory>/<datafilename>' reuse;

regards,

S.Rajeshkumar