Query to retrieve user tables only

Hi,

I need to retrieve a list of tables created by users.

The following query is not suitable because it retrieves system (or not user defined) tables as well:

SELECT * FROM user_tables

So far I've been using the following one:

SELECT table_name, tablespace_name FROM user_tables WHERE table_name NOT LIKE '%$%' AND tablespace_name <> 'SYSAUX'

Can you confirm that this is the right way of achieving this? Or is there a more accurate query?

Thank you in advance. Received on Mon Mar 05 2007 - 16:36:35 CST