Oracle System tables.

To get all columns in user tables.

select * from USER_TAB_COLUMNS order by TABLE_NAME, COLUMN_NAME; 

To get all user tables.

select * from user_tables; 

To get indexs

select * from user_indexes;