我需要 把 目标数据源中的表 获取到表的字段和字段的类型等信息，然后在目标数据源中创建表，并解析2个不同数据库的表的字段，用Java 创建表

import java.util.HashMap;
import java.util.Map;

public class OracleToMySQLTypeConverter {

    private static Map<String, String> typeMapping;

    static {
        typeMapping = new HashMap<>();
        typeMapping.put("NUMBER", "DECIMAL");
        typeMapping.put("VARCHAR2", "VARCHAR");
        typeMapping.put("CHAR", "CHAR");
        typeMapping.put("NCHAR", "CHAR");
        typeMapping.put("NVARCHAR2", "VARCHAR");
        typeMapping.put("DATE", "DATE");
        typeMapping.put("TIMESTAMP", "DATETIME");
        typeMapping.put("CLOB", "TEXT");
        typeMapping.put("NCLOB", "TEXT");
        typeMapping.put("BLOB", "BLOB");
        typeMapping.put("BINARY_DOUBLE", "DOUBLE");
        typeMapping.put("BINARY_FLOAT", "FLOAT");
        typeMapping.put("RAW", "BINARY");
        typeMapping.put("LONG RAW", "BLOB");
        typeMapping.put("LONG", "TEXT");
        typeMapping.put("FLOAT", "FLOAT");
        typeMapping.put("REAL", "REAL");
        typeMapping.put("INTEGER", "INT");
        typeMapping.put("SMALLINT", "SMALLINT");
        typeMapping.put("NUMERIC", "NUMERIC");
        typeMapping.put("BOOLEAN", "BOOLEAN");
        typeMapping.put("VARCHAR", "VARCHAR");
        typeMapping.put("NVARCHAR", "VARCHAR");
        typeMapping.put("VARCHAR2", "VARCHAR");
        typeMapping.put("NCHAR", "CHAR");
        typeMapping.put("CHAR", "CHAR");
        typeMapping.put("LONGVARCHAR", "TEXT");
        typeMapping.put("BINARY", "BINARY");
        typeMapping.put("VARBINARY", "VARBINARY");
        typeMapping.put("LONGVARBINARY", "BLOB");
        typeMapping.put("BLOB", "BLOB");
        typeMapping.put("CLOB", "TEXT");
        typeMapping.put("NCLOB", "TEXT");
        typeMapping.put("ROWID", "VARCHAR");
        // 添加其他类型映射
    }

    public static String convertType(String oracleType) {
        String mysqlType = typeMapping.get(oracleType);
        return mysqlType != null ? mysqlType : "UNKNOWN";
    }

    public static void main(String[] args) {
        String oracleFieldType = "NUMBER";
        String mysqlFieldType = convertType(oracleFieldType);
        System.out.println("Oracle Field Type: " + oracleFieldType);
        System.out.println("MySQL Field Type: " + mysqlFieldType);
    }
}