Re: what to check before dropping a tablespace

From: Anna C. Dent <anacedent_at_hotmail.com>
Date: Sat, 06 Sep 2003 10:08:50 -0700
Message-ID: <Cwo6b.113857$kP.1613@fed1read03>

Joe wrote:

> I am going to drop a tablespace
> and i want to sure the tablespace is empty before i really drop it
> i know i can query the dba_tables and dba_indexes to see if there is any
> table or index resides on this tablespace
> what else do i need to check?

Oracle will NOT allow you to drop a tablespace when objects exist in it.

>
> also
> i would like to know which user have privileges on this tablespace, and what
> privileges it is
> so that i can create a new tablespace and assign those privileges to those
> users on the new tablespace
> can anyone suggest me where to find these information?

User do NOT get "privileges on this tablespace". They are granted privs on DB objects.
At most they have a quota for this tablespace. Received on Sat Sep 06 2003 - 12:08:50 CDT