> ## Documentation Index
> Fetch the complete documentation index at: https://docs.datazone.co/llms.txt
> Use this file to discover all available pages before exploring further.

# Oracle

> Oracle is a powerful enterprise-grade relational database management system.

# Overview

Oracle Database is an enterprise-class database management system that provides comprehensive and advanced data management features. Datazone provides native integration with Oracle to read data directly from your databases.

## Connection Parameters

| Parameter    | Required | Description                                                  |
| ------------ | -------- | ------------------------------------------------------------ |
| Name         | Yes      | A unique identifier for your Oracle source                   |
| Host         | Yes      | The hostname or IP address of your Oracle database server    |
| Port         | Yes      | The port number on which Oracle is running (default: 1521)   |
| Service Name | Yes      | The Oracle service name for your database                    |
| Schema Name  | No       | Optional schema name to restrict access to specific schema   |
| User         | Yes      | Username with appropriate permissions to access the database |
| Password     | Yes      | Password for the specified user                              |

## Required Permissions

The Oracle user account needs the following permissions:

* `SELECT` - For reading data from tables and views
* `SELECT ANY TABLE` - For reading from tables in other schemas
* `SELECT_CATALOG_ROLE` - For accessing data dictionary views
* `CREATE SESSION` - For connecting to the database

## Limitations

Be aware of the following limitations when working with Oracle sources:

* Some Oracle-specific data types may be converted to standard formats
* LONG and LONG RAW data types have size limitations
* Individual query size and timeout limits apply
* The Oracle instance and Datazone should ideally be in the same network for optimal performance
* Binary data types require special handling

## Next Steps

After configuring your Oracle source:

1. Create extracts to specify which tables to ingest
2. Configure scheduling for recurring extracts
3. Integrate the source into your data pipelines

For more information about working with extracts and pipelines, refer to their respective documentation sections.