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]

Hello and thanks for all the respons.

I've got metalink access and have been reading oracle note 111316.1 and note 1029252.6 How to resize a datafile.

I now understand that my best option is to leave the data-file.

Maybe resize it.

Best regards Harald Vedvik