Get information on all the tables you have access to using all_nested_tables. : all_nested_tables « System Tables Data Dictionary « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. System Tables Data Dictionary
3. all_nested_tables

SQL>
SQL> desc all_nested_tables;
 Name          Null?    Type

 OWNER                  VARCHAR2(30)
 TABLE_NAME             VARCHAR2(30)
 TABLE_TYPE_OWNER       VARCHAR2(30)
 TABLE_TYPE_NAME        VARCHAR2(30)
 PARENT_TABLE_NAME      VARCHAR2(30)
 PARENT_TABLE_COLUMN    VARCHAR2(4000)
 STORAGE_SPEC           VARCHAR2(30)
 RETURN_TYPE            VARCHAR2(20)
 ELEMENT_SUBSTITUTABLE  VARCHAR2(25)

SQL>
SQL> --select * from all_nested_tables;