RE: Is is safe to drop an empty tablespace?

 
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Bobak, Mark
Sent: Thursday, March 27, 2008 10:53 AM
To: Kurt-Franke@xxxxxx; genegurevich@xxxxxxxxxxxx; piontekdd@xxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
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@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


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


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


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

Other related posts: