Table of Contents

Search

  1. Preface
  2. Introduction to PowerExchange
  3. DBMOVER Configuration File
  4. Netport Jobs
  5. PowerExchange Message Logs and Destination Overrides
  6. SMF Statistics Logging
  7. PowerExchange Security
  8. Secure Sockets Layer Support
  9. PowerExchange Alternative Network Security
  10. PowerExchange Nonrelational SQL
  11. PowerExchange Globalization
  12. Using the PowerExchange ODBC Drivers
  13. PowerExchange Datatypes and Conversion Matrix
  14. DTL__CAPXTIMESTAMP Time Stamps
  15. PowerExchange Glossary

Oracle DBMOVER Statements

Oracle DBMOVER Statements

You can include DBMOVER statements specific to Oracle data sources.
The following table briefly defines the DBMOVER statements specific to Oracle data sources and provides cross-references to the complete description of the statements:
Statement
Description
Reference
CAPI_CONNECTION - ORAD
Specifies the CAPI parameters to use for PowerExchange Express CDC for Oracle sources.
CAPI_CONNECTION - ORCL
Specifies the CAPI parameters for PowerExchange Oracle CDC with LogMiner sources.
ORA_ERRORFILE
Specifies the name of the user-customized SQL error file that PowerExchange uses for Oracle bulk data movement operations.
ORACLE_CAPTURE_TYPE
Specifies which PowerExchange Oracle CDC solution is in use for a PowerExchange installation: PowerExchange Express CDC for Oracle or PowerExchange Oracle CDC with LogMiner.
ORACLE_UNHANDLED_NUMASCHAR
Controls whether PowerExchange handles the following types of numeric columns in Oracle source tables in a manner that prevents data loss:
  • NUMBER columns that have a precision greater than 28 or an undefined length
  • FLOAT columns that have a precision greater than 15 significant digits
ORACLECODEPAGE
Specifies the PowerExchange and PowerCenter code pages to use for a specific Oracle database used in Oracle bulk data movement, if the NLS_LANG environment variable specifies a character set other than UTF8 or AL32UTF8.
ORACLEID
Specifies the Oracle source database and connection information for PowerExchange CDC with Oracle LogMiner.