Re: What are considered Oracle system tables?

From: Daniel A. Morgan <damorgan_at_exesolutions.com>
Date: Thu, 07 Mar 2002 23:50:01 +0000
Message-ID: <3C87FCA9.A7A6EC50@exesolutions.com>

SELECT table_name
FROM user_tables

is all tables owned by your schema.

SELECT table_name
FROM all_tables

is all tables you have some rights to. This view also has a column named "OWNER" to see which schema owns the tables.

Daniel Morgan

"D. Alvarado" wrote:

> I'm connecting to an Oracle 8 server using JDBC. I'm creating an app
> that allows the user to get a listing of all db tables and query any
> he chooses. However, I don't really want ALL talbes, only user
> created tables (i.e. non-system tables). I don't really know how to
> distinguish system tables from user tables, I assume it would be by
> schema. Are there certain schemas that define system tables? What
> are they? Is there a better way to get a listing of user created
> tables?
>
> Thanks in advance, Dave A.
Received on Thu Mar 07 2002 - 17:50:01 CST