User Available Tables in Oracle

To get all the tables that a user(you) have access to in a given schema use :-

select table_name from all_tables
where owner = '<SCHEMA_NAME>';

Note that the schema_name MUST be in capitals as Oracle usually store it that way.