Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Simple Question: How to Select All User Created Tables?

Re: Simple Question: How to Select All User Created Tables?

From: DA Morgan <damorgan_at_psoug.org>
Date: Thu, 23 Aug 2007 16:11:31 -0700
Message-ID: <1187910688.496043@bubbleator.drizzle.com>


Stuart wrote:
> Hi,
>
> I'm fairly new to Oracle and I was wondering if there was a simple way
> to return a list of all user created tables (with no system
> tables)..
>
> Any help or direction would be great!
>
> Thanks,
>
> Stuart

SELECT owner, table_name
FROM all_tables
WHERE owner NOT LIKE '%SYS%';

You will need to look at dba_users and determine for yourself, what is and is not, user created as you define it.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Thu Aug 23 2007 - 18:11:31 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US