RE: Is is safe to drop an empty tablespace?

From: Bobak, Mark <>
Date: Thu, 27 Mar 2008 10:53:09 -0400
Message-ID: <>

Hmm...ok, I stand corrected. Thanks Kurt, I wasn't aware of that.

I just assumed they'd get dropped like a dependent object.


Mark J. Bobak
Senior Database Administrator, System & Product Technologies
789 E. Eisenhower, Parkway, P.O. Box 1346
Ann Arbor MI 48106-1346
+1.734.997.4059  or +1.800.521.0600 x 4059

ProQuest...Start here.

-----Original Message-----
From: [] On Behalf Of Kurt Franke
Sent: Thursday, March 27, 2008 10:41 AM
To: Bobak, Mark;;
Subject: RE: Is is safe to drop an empty tablespace?

> 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 -- --
Received on Thu Mar 27 2008 - 09:53:09 CDT

Original text of this message