RE: Is is safe to drop an empty tablespace?
From: Kurt Franke <Kurt-Franke_at_web.de>
Date: Thu, 27 Mar 2008 15:40:54 +0100
Message-Id: <943276678@web.de>
Date: Thu, 27 Mar 2008 15:40:54 +0100
Message-Id: <943276678@web.de>
>
>
> Having quotas on a tablespace won’t prevent him from dropping
> it. Those quotas will just go away.
>
No.
They won't go away - they'll persist in the data dictionary and will take effect
later if a tablespace with the same name is created again.
And it cannot be removed as long as no tablespace with this name exists.
regards
kf
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Mar 27 2008 - 09:40:54 CDT