export ORACLE_HOME=/opt/oracle/product/12.1.0/client_1
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME:/lib:/lib64
export PATH=$PATH:/opt/oracle/product/12.1.0/client_1

cd /var/lib/pgproee/bp

[root@bp-dn-db03 bp]# ls -1
config
data
data_
export_schema.sh
import_all.sh
reports
schema
sources

[root@bp-dn-db03 bp]# egrep -v '(^#|^;|^\s*$|^\s*\t*#)' ./config/ora2pg.conf
ORACLE_HOME     /opt/oracle/product/12.1.0/client_1
ORACLE_DSN      dbi:Oracle:host=192.168.70.10;port=1521;sid=BPMF
ORACLE_USER     system
ORACLE_PWD      system
USER_GRANTS     1
DEBUG           0
ORA_INITIAL_COMMAND
EXPORT_SCHEMA   1
SCHEMA  BP
CREATE_SCHEMA   1
COMPILE_SCHEMA  0
PG_SCHEMA       BP,pg_catalog,public
TYPE            TABLE
DISABLE_COMMENT         0
EXTERNAL_TO_FDW         1
TRUNCATE_TABLE  1
USE_TABLESPACE          0
REORDERING_COLUMNS      0
CONTEXT_AS_TRGM         0
FTS_INDEX_ONLY  1
USE_UNACCENT            0
USE_LOWER_UNACCENT      0
KEEP_PKEY_NAMES 0
PKEY_IN_CREATE          0
FKEY_ADD_UPDATE         never
FKEY_DEFERRABLE 0
DEFER_FKEY      0
DROP_FKEY       0
DISABLE_SEQUENCE        1
DISABLE_TRIGGERS        1
PRESERVE_CASE   0
INDEXES_RENAMING        0
USE_INDEX_OPCLASS       0
PREFIX_PARTITION        0
DISABLE_PARTITION       0
WITH_OID                0
ORA_RESERVED_WORDS      audit,comment
USE_RESERVED_WORDS      0
OUTPUT          output.sql
BZIP2
FILE_PER_CONSTRAINT     1
FILE_PER_INDEX  1
FILE_PER_TABLE  1
FILE_PER_FUNCTION       1
STOP_ON_ERROR           1
COPY_FREEZE             0
DATA_TYPE       NVARCHAR2:text,DATE:timestamp,LONG:text,LONG RAW:bytea,CLOB:text,NCLOB:text,BLOB:bytea,BFILE:bytea,RAW:uuid,ROWID:oid,FLOAT:decimal,DEC:decimal,DECIMAL:decimal,DOUBLE PRECISION:double precision,INT:integer,INTEGER:integer,REAL:real,SMALLINT:smallint,BINARY_FLOAT:double precision,BINARY_DOUBLE:double precision,TIMESTAMP:timestamp,XMLTYPE:xml,BINARY_INTEGER:integer,PLS_INTEGER:integer,TIMESTAMP WITH TIME ZONE:timestamp with time zone,TIMESTAMP WITH LOCAL TIME ZONE:timestamp with time zone
PG_NUMERIC_TYPE 1
PG_INTEGER_TYPE 1
DEFAULT_NUMERIC bigint
ENABLE_MICROSECOND      1
GEN_USER_PWD    0
FORCE_OWNER     1
DATA_LIMIT      10000
NOESCAPE        0
TRANSACTION     serializable
STANDARD_CONFORMING_STRINGS     1
LONGREADLEN     1047552
NO_LOB_LOCATOR  0
XML_PRETTY      0
LOG_ON_ERROR            0
TRIM_TYPE               BOTH
INTERNAL_DATE_MAX       49
JOBS            16
ORACLE_COPIES   16
PARALLEL_TABLES 16
DROP_INDEXES    0
/# Specifies whether transaction commit will wait for WAL records to be written
SYNCHRONOUS_COMMIT      0
EXPORT_INVALID  4
PLSQL_PGSQL     0
NULL_EQUAL_EMPTY        0
EMPTY_LOB_NULL          1
PACKAGE_AS_SCHEMA       1
REWRITE_OUTER_JOIN      1
ESTIMATE_COST           0
COST_UNIT_VALUE         5
DUMP_AS_HTML            0
TOP_MAX                 10
HUMAN_DAYS_LIMIT        5
PG_SUPPORTS_WHEN                1
PG_SUPPORTS_INSTEADOF   1
PG_SUPPORTS_MVIEW       1
PG_SUPPORTS_CHECKOPTION 1
PG_SUPPORTS_IFEXISTS    1
BITMAP_AS_GIN           1
PG_BACKGROUND           0
AUTODETECT_SPATIAL_TYPE 1
CONVERT_SRID            1
DEFAULT_SRID            4326
GEOMETRY_EXTRACT_TYPE   INTERNAL
FDW_SERVER      orcl
MYSQL_PIPES_AS_CONCAT           0
MYSQL_INTERNAL_EXTRACT_FORMAT   0