Generic Oracle

Last updated on Mar 05, 2024

Oracle database is a cross-platform Relational Database Management System (RDBMS) that can run on various hardware across operating systems including Windows Server, Unix, and various distributions of GNU/Linux. It is commonly referred to as Oracle database, OracleDB, or simply Oracle. The database software endorses transaction processing, business intelligence and different analytics applications, and used by both small and large enterprises to store and manage data.

Limitations

  • Redo Log does not support user-defined data types. Therefore, fields with such data types are not captured in the log and are lost.



See Also


Revision History

Refer to the following table for the list of key updates made to this page:

Date Release Description of Change
Mar-05-2024 2.21 Added the Data Replication section.
Jan-22-2024 2.19.2 Updated section, Object and Query Mode Settings to add a note about the enhanced object selection flow available for log-based Pipelines.
Jan-10-2024 2.19 Updated section, Specify Oracle Connection Settings as per latest Hevo functionality.
Nov-03-2023 NA Added section, Object and Query Mode Settings.
Oct-09-2023 NA Added section, Set PGA_AGGREGATE_LIMIT.
Apr-21-2023 NA Updated section, Specify Oracle Connection Settings to add a note to inform users that all loaded Events are billable for Custom SQL mode-based Pipelines.
Mar-09-2023 2.09 Updated section, Specify Oracle Connection Settings to mention about SEE MORE in the Select an Ingestion Mode section.
Dec-19-2022 2.04 Updated section, Specify Oracle Connection Settings to add information that you must specify all fields to create a Pipeline.
Dec-07-2022 2.03 Updated section, Specify Oracle Connection Settings to mention about including skipped objects post-Pipeline creation.
Dec-07-2022 2.03 Updated section, Specify Oracle Connection Settings to mention about the connectivity checker.
Jun-16-2022 NA Added section, Connecting to a Local Database.
Dec-06-2021 1.77 Added a See Also link to the Pipeline failure due to Redo Log expiry page.
Nov-22-2021 NA Updated the Limitations section.
Feb-22-2021 1.57 Added sections:
- Create a User and Grant Privileges
- Retrieve the Service Name

Tell us what went wrong