Below is just a simple query to get all tables from a schema from an Oracle database.

SELECT TABLE_NAME 
FROM ALL_TABLES 
WHERE OWNER='MY_SCHEMA';