To view the user tables.

select * from tab;

To view the user indexes.

select index_name, table_name from user_indexes;