Re: What are considered Oracle system tables?

From: Ganesh Raja <ganesh_at_gtfs-gulf.com>
Date: 10 Mar 2002 02:19:30 -0800
Message-ID: <a8aed4.0203100219.36ada2f8@posting.google.com>

"Prasad Yarlagadda" <prasad.yarlagadda_at_motorola.com> wrote in message news:<a6b7ad$9et1_at_nntp.cig.mot.com>...
> "select tname from tab" gives the list of tables created by the user
>
> Prasad
>

As a Pointer to the above Be aware that they also show u the views and synonyms created by you...

I would Go With Morgan's suggestion.

>
>
> "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.

Regards,
Ganesh R Received on Sun Mar 10 2002 - 04:19:30 CST