1. Oracle GoldenGate Classic Architecture Documentation
  2. Prepare
  3. Prepare Your Database for Oracle GoldenGate Classic Architecture
  4. Sybase
  5. Understanding What's Supported for Sybase
  6. Non-Supported Operations and Objects for Sybase

Non-Supported Operations and Objects for Sybase

This section lists the data operations and database objects that Oracle GoldenGate does not support.

  • Data that is encrypted with a user-defined password.

  • Extraction or replication of DDL (data definition language) operations.

  • Multi-Extract configuration. Only one Extract can reserve a context to read the Sybase transaction logs.

  • Because SHOWSYNTAX is supported in the DYNSQL mode, NODYNSQL is deprecated.

  • Table names that contain data with an underscore followed by some characters then a space (for example, 'zzz_j') is not supported. Oracle GoldenGate cannot process records containing this type of character string with GGSCI, DEFGEN, EXTRACT, or REPLICAT. Additionally, this type of data cannot be used with Oracle GoldenGate wildcard (*). If you do have this type of data in your table name, you must drop this kind of table name from your database, and then they restart the application to process and respect Oracle GoldenGate wildcard.