Existing referential constraints do not allow you to perform a detach. You must drop the referential constraints before you perform the detach on the dbspace/partition or table.