Re: Show user's tables & views

In article <38ibl1$176n_at_ctsc.hkbc.hk>, PM Wong <s11976_at_ctsc.hkbc.hk> wrote:
>Sorry for this trivial question. We have many old users which are to be
>dropped. It is good practice (I think) to know what tables (and/or views)
>they created so we can drop them before we revoke connect & resource
>from such users
>But I don't know how to list all the tables and views created by all users
>of the tablespace.
>Can someone tell me the command please

Assuming you are using Oracle7, you can simply use:

SQL> drop user scott including contents;

Someone else have posted a detailed solution for Oracle6 (using spool file) so I don't want to repeat here.

-- 
"And this is all I have to say about that..."

                                    `o<'
---------------------------------oo0(__)0oo--------------------------------
   __    __  __  __  __  _  _    __   U  __  _ __ _
  /__\  (  )(  )(  )(  )( \( )  (  )    /__\( (  ) )  "You may be an idoit,
 /(__)\  )(__\ () /  )(  )  (    )(__  /(__)\\  / /    but try not to be
(__)(__)(____)\__/  (__)(_)\_)  (____)(__)(__)\/\/     stupid."   - F. Gump