becuase you had data spanning tablespaces and droppping one of them would have broken your foreign key constraints.

Did you not read the error, the part where it told you EXACTLY what the problem was