How to find out what tables and sequences are available

login as any valid user SQL> select table_name from ALL_TABLES; To list user tables SQL> select table_name from USER_TABLES; To list user sequences SQL> select sequence_name from USER_SEQUENCES;