ora2pg工具或者外部表插件oracle_fdw，oracle_fdw支持按schema自动导入，语法非常灵活：

IMPORT FOREIGN SCHEMA "SCOTT"
FROM SERVER server_ora 
INTO public
OPTIONS (case 'lower', readonly 'true',max_long '32767',sample_percent '100', prefetch  '0');