RE: Is is safe to drop an empty tablespace?
From: Bobak, Mark <Mark.Bobak_at_proquest.com>
Date: Thu, 27 Mar 2008 10:53:09 -0400
Message-ID: <667C10D184B2674A82068E06A78382B51DC38A73@AAPQMAILBX01V.proque.st>
Date: Thu, 27 Mar 2008 10:53:09 -0400
Message-ID: <667C10D184B2674A82068E06A78382B51DC38A73@AAPQMAILBX01V.proque.st>
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_at_proquest.com www.proquest.com www.csa.com ProQuest...Start here. -----Original Message----- From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Kurt Franke Sent: Thursday, March 27, 2008 10:41 AM To: Bobak, Mark; genegurevich_at_discover.com; piontekdd_at_gmail.com Cc: oracle-l_at_freelists.org Subject: RE: Is is safe to drop an empty tablespace?Received on Thu Mar 27 2008 - 09:53:09 CDT
>
>
> 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-l -- http://www.freelists.org/webpage/oracle-l