- #---------------------------------#
- #---------------------------------#
- # Set the Oracle home directory
- ORACLE_HOME /usr/lib/oracle/18.3/client64
- # Set Oracle database connection (data source, user, password)
- ORACLE_DSN dbi:Oracle:host=192.168.***.***;sid=xe;port=****
- ORACLE_USER ***
- ORACLE_PWD ****
- # Oracle schema/owner to use
- #SCHEMA SCHEMA_NAME
- SCHEMA TIANYA SYSTEM
- #--------------------------
- # EXPORT SECTION (Export type and filters)
- #--------------------------
- # Type of export. Values can be the following keyword:
- # TABLE Export tables, constraints, indexes, ...
- # PACKAGE Export packages
- # INSERT Export data from table as INSERT statement
- # COPY Export data from table as COPY statement
- # VIEW Export views
- # GRANT Export grants
- # SEQUENCE Export sequences
- # TRIGGER Export triggers
- # FUNCTION Export functions
- # PROCEDURE Export procedures
- # TABLESPACE Export tablespace (PostgreSQL>= 8 only)
- # TYPE Export user-defined Oracle types
- # PARTITION Export range or list partition (PostgreSQL>= v8.4)
- # FDW Export table as foreign data wrapper tables
- # MVIEW Export materialized view as snapshot refresh view
- # QUERY Convert Oracle SQL queries from a file.
- # KETTLE Generate xml ktr template files to be used by Kettle.
- TYPE TABLE VIEW COPY
- # By default all output is dump to STDOUT if not send directly to PostgreSQL
- # database (see above). Give a filename to save export to it. If you want
- # a Gzip'd compressed file just add the extension .gz to the filename (you
- # need perl module Compress::Zlib from CPAN). Add extension .bz2 to use Bzip2
- # compression.
- OUTPUT output2.sql
- # Base directory where all dumped files must be written
- #OUTPUT_DIR /var/tmp
- OUTPUT_DIR /application/ora2pg/output
来源: http://www.linuxidc.com/Linux/2019-03/157588.htm