/* List all your objects names (tables, views, indexes, sequences, etc.) */

SELECT   table_name
 FROM    user_tables;

SELECT   view_name
 FROM    user_views;

SELECT   object_name, object_type
 FROM    user_objects
ORDER BY object_type DESC;