public static String map2TypeForDBMS(String type){
  if (type.contains("DATABASE LINK"))   return "DB_LINK";
  if (type.equals("JOB"))   return "PROCOBJ";
  if (type.equals("SCHEDULE"))   return "PROCOBJ";
  if (type.equals("PROGRAM"))   return "PROCOBJ";
  if (type.equals("PACKAGE"))   return "PACKAGE_SPEC";
  return type.replace(" ","_");
}

public static String map2TypeForDBMS ( String type ) { if ( type . contains ( "DATABASE LINK" ) ) return "DB_LINK" ; if ( type . equals ( "JOB" ) ) return "PROCOBJ" ; if ( type . equals ( "SCHEDULE" ) ) return "PROCOBJ" ; if ( type . equals ( "PROGRAM" ) ) return "PROCOBJ" ; if ( type . equals ( "PACKAGE" ) ) return "PACKAGE_SPEC" ; return type . replace ( " " , "_" ) ; }
oracle types in user_table without underscore , for example package body but in dbms_metadata with underscore package_body
