Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

selecting all user tables from all_tables

366358Nov 6 2002
I'm trying to select allthe user tables from all_tables. When I select table_name from all_tables, it returns a bunch of tables created by the system with owner such as AURORA$JIS$UTILITY$, CTXSYS, MDSYS, SYS, etc. I can't use select table_name from user_tables because it return the tables owned by only the current user. I want all tables owned by all users, except for default system stuff. Does anyone know of a way to do this? For example, Informix has a minimum user table id(e.g. any tables with id's greater than 100 are user tables), and microsoft sql server has a field t.type set to 'u' for user tables. I haven't seen a way to distinguish between user and system tables in oracle yet though. Again, I only want all tables owned by all users, except for default system stuff. Any help would by greatly appreciated. Thanks in advance,

Torin
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 4 2002
Added on Nov 6 2002
2 comments
1,546 views