Using Oracle as a data warehouse

This section describes how to set up Oracle as a data warehouse in a Compose project.

When loading a huge number of records (i.e. hundreds of millions), the UNDO/REDO/TEMP tablespace on the Oracle database must be large enough to hold the data being loaded.

It contains the following topics:

Prerequisites
Oracle data types
Defining the connection parameters

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!

Leave your feedback here