Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Drop datafile from tablespace

This question is answered

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
October 22, 2007 at 21:39 PM
0 Likes
Correct Answer
replied
October 22, 2007 at 21:03 PM

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.

0 Likes 0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question

11 replies