Drop datafile from tablespace

[#1]

I'm new to oracle.

After I extended a tablespace I understood that it was too large.

I've been reading about how to drop a tablespace, but I don't want to drop the entire tablespace. I just want to drop the last datafile of this tablespace.

I know how to drop tablespaces in sapdba and brtools, but I don't know how I can drop one specific datafile (number 29) of the tablespace PSAPBTABD?

Please Help med.

Best regards

Harald V

[Former Member]

Thanks again for your answers Baran.

I have no metalink account.

Best regards.

Harald Vedvik

[Former Member]

Hi Harals,

Check note 758563 for metalink access for SAP customers.

Thanks

Prince Jose