Re: What are considered Oracle system tables?

From: Prasad Yarlagadda <prasad.yarlagadda_at_motorola.com>
Date: Fri, 8 Mar 2002 14:35:25 -0600
Message-ID: <a6b7ad$9et1@nntp.cig.mot.com>

"select tname from tab" gives the list of tables created by the user

Prasad

"D. Alvarado" <laredotornado_at_zipmail.com> wrote in message news:9fe1f2ad.0203071155.640070bf_at_posting.google.com...
> 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 Fri Mar 08 2002 - 14:35:25 CST