RE: Is is safe to drop an empty tablespace?
Date: Thu, 27 Mar 2008 13:03:03 -0400
Message-ID: <D1DC33E67722D54A93F05F702C99E2A902236E61@usahm208.amer.corp.eds.com>
I do not know if quotas still hang around on 10g or 11g but in earlier versions of Oracle that was one of the problems you could encounter on a full import. Because Oracle added the quotas as a single statement and because Oracle failed to drop quotas on tablespaces when the tablespace was dropped the quota assignments would fail on import. No quotas then tables/indexes did not import correctly.
I was under the impression Oracle fixed the import problem but I have not checked recently nor does a fix to the import process mean the quotas are dropped like what should happen. Something else to add to the list of things to check out.
- Mark D Powell -- Phone (313) 592-5148
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Bobak, Mark
Sent: Thursday, March 27, 2008 10:53 AM
To: Kurt-Franke_at_web.de; genegurevich_at_discover.com; piontekdd_at_gmail.com
Cc: oracle-l_at_freelists.org
Subject: RE: Is is safe to drop an empty tablespace?
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 - 12:03:03 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 -- http://www.freelists.org/webpage/oracle-l