/* Show table names, tablespace name, status, etc.  */

SELECT * 
  FROM user_tables;


/* Show additional view names  */

SELECT view_name
  FROM user_views;