import java.sql.Connection; import java.sql.DatabaseMetaData; import java.sql.DriverManager; import java.sql.ResultSet; public class Main { public static void main(String[] args) throws Exception { Class.forName("oracle.jdbc.driver.OracleDriver"); String databaseURL = ""; String user = ""; String password = ""; String schema = ""; Connection conn = DriverManager.getConnection(databaseURL, user, password); try { DatabaseMetaData dmd = conn.getMetaData(); ResultSet rs; rs = dmd.getTables(null, schema, "%", new String[] { "TABLE" }); while (rs.next()) { System.out.println(rs.getString("TABLE_SCHEM") + "." + rs.getString("TABLE_NAME")); } } finally { conn.close(); } } }