Oracle databases: Get tables from a specific schema Feb 17, 2016 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';