Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Simple Question: How to Select All User Created Tables?
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.orgReceived on Thu Aug 23 2007 - 18:11:31 CDT