Drop datafile from tablespace

[Former Member]

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 · Accepted solution]

Harald,

you have a few possibilities:

1. decrease the size of your datafile to a small value:

brspace -c -u / -f dfalter

2. reorg fully your tablesapce

check Note 646681 - Reorganizing tables with BRSPACE

as you can see, you cannot drop a datafile easily in Oracle 9.