Configure a source Oracle database

This section describes how to configure your source Oracle database so that Datastream can pull data from it. Datastream can pull changes to data from on-premises or cloud-hosted Oracle databases, including Oracle relational database service (RDS).

Datastream uses Oracle LogMiner, which is part of Oracle Database, to query archived redo log files. When configuring your source Oracle database, you'll ensure that it runs in ARCHIVELOG mode, so that the logs are archived. Redo log files contain information about the history of activity on a database. For more information about how Datastream works with these log files, see Work with Oracle database redo log files.

Configure a source Oracle database

Before you can use Datastream to pull data from your source Oracle database, you must configure your database by:

• Setting up archive logging to track changes in your database, such as the INSERT, UPDATE, DELETE, and RENAME operations.
• Granting the appropriate privileges to the user account that will be used to connect to your database.
• Granting your user account SELECT access to the DBA_EXTENTS view in your database.
• Defining a data retention policy for your database to determine which data will be archived, how long it will be kept, should the data at the end of the retention period be archived or destroyed, and so on.

Supported databases

Datastream works with the following types of Oracle databases:

• Amazon RDS for Oracle
• Self-managed Oracle database
• Self-hosted Oracle pluggable database

What's next

• Learn how to configure an Amazon RDS for Oracle database to work with Datastream.
• Learn how to configure a self-managed Oracle database to work with Datastream.
• Learn how to configure a self-hosted Oracle pluggable database to work with Datastream.