Remove datafile from TableSpace

[Former Member]

Hi,

How to Remove datafile from TableSpace in oracle.

Thanku

[Former Member · Accepted solution]

Hi,

The table deletion sapce is not recommeded by SAP. Please donot do it.

archive the data from table to free the space.

Thanks & Regards,

Vidyadhar K

[Former Member]

Hi,

The table deletion sapce is not recommeded by SAP. Please donot do it.

archive the data from table to free the space.

Thanks & Regards,

Vidyadhar K

[Former Member]

i would like to know why you want to delete the data file from tablesapce.It is a drangerous option.

If you want to do so then create a new control file excluding the file you want to delete.then delete the file at O/S level manually.

Regards

Ashok Dalai