Disk Space

[Former Member]

Hi,

We had an scenario can anyone will help...

We have done a realignment in R/3 and and for this we started reloading the data for COPA cube( We deleted the previous data and reloaded again). My college he had filled filling th data from PSA to Cube and ODS... After completion of 80% our loads started gettitng failed because of no space in Oracle... after analysis our basis team had informed us stating thir is not space in Oracle.. I started deleting the PSA whatever i have done the free space it has been alocated to ODS tables but other table does not have a spcae... do anyone has an tem idea where we can load the data tem 50,00000 records and later add the desk space...

How to extend the table.. please could you give me the stps ..

it had happen in Production please

Thank

[Former Member · Accepted solution]

Your question is not very clear.

What I understand is that if you dont have space available for any table or tablespace .You have two options.

1. add datafile to your tablespace .It will solve your space problem

2.Reorganise your table so that the fragmented space is recovered.

3.Delete the unwanted data from the PSA and then try to load data.

4.You have to do the DB analysis and proceed with that.

Hope it helps.

Amit

[Former Member]

What is the D b version you have?

You can try to set the max extent to unlimited for table and try.

Amit