Drop datafile from tablespace
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
Eric Brunelle replied
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.