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 -- Mark J. Bobak Senior Database Administrator, System & Product Technologies ProQuest 789 E. Eisenhower, Parkway, P.O. Box 1346 Ann Arbor MI 48106-1346 +1.734.997.4059 or +1.800.521.0600 x 4059 mark.bobak@xxxxxxxxxxxx www.proquest.com www.csa.com ProQuest...Start here. -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Kurt Franke Sent: Thursday, March 27, 2008 10:41 AM To: Bobak, Mark; genegurevich@xxxxxxxxxxxx; piontekdd@xxxxxxxxx Cc: oracle-l@xxxxxxxxxxxxx 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 -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l