DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: users own tables

Threaded View

  1. 04-19-2004, 08:48 AM #2
    efrijters's Avatar
    efrijters
    efrijters is offline humble grasshopper
    Join Date
    Oct 2002
    Location
    Breda, The Netherlands
    Posts
    317
    Something like this?

    Code:
    select owner
  from (select owner,count(tablespace_name) from dba_tables group by owner)
  group by owner
  having count(*)>1
/
    HTH,
    Erik
    Last edited by efrijters; 04-19-2004 at 08:52 AM.
    An expert is one who knows more and more about less and less until he knows absolutely everything about nothing.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Click Here to Expand Forum to Full Width