RE: Is is safe to drop an empty tablespace?

  • From: Kurt Franke <Kurt-Franke@xxxxxx>
  • To: Mark.Bobak@xxxxxxxxxxxx, genegurevich@xxxxxxxxxxxx, piontekdd@xxxxxxxxx
  • Date: Thu, 27 Mar 2008 15:40:54 +0100

> 
> 
> 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


--
//www.freelists.org/webpage/oracle-l


Other related posts: