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,
"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.
Florianópolis - SC - Brasil
-- Android Development Center
-- Cloud Development Project Center
-- HTML5 Development Center
-- Windows Mobile Development Center