I'm a oracle beginner. I need to retrieve the metadata from objetcs (tables,
indexes and foreign keys). Which is the best way to do so? Through Views or
directly accessing system.tables?
If I make a select at USER_ALL_TABLES, I only need the user created ones,
somethig like:

"select * from sys.user_all_tables where tablespace_name = 'TS_MODELO'
and table_name not like 'SM%'
and table_name not like 'EVT_%' "

But if there is some user's table starting with 'sm' or 'evt_' this is a bad
Can anyone help?

Thanks a lot in advance.

Ricardo Costa
Florianópolis - SC - Brasil