## What does Atlan crawl from Oracle?

URL: https://docs.atlan.com/apps/connectors/database/oracle/references/what-does-atlan-crawl-from-oracle

> During an Oracle crawl, Atlan extracts metadata for Databases, Schemas, Tables, Views, and Procedures. Reference tables map each Oracle property to its Atlan asset.

During an Oracle crawl, Atlan extracts metadata for Databases, Schemas, Tables, Views, and Procedures and maps it to Atlan's internal asset model. The tables below list, for each asset type, which Oracle properties are read and how they appear on the corresponding Atlan asset.

## Databases

Atlan maps databases from Oracle to its `Database` asset type.

| Source property | Atlan property |
| --- | --- |
| `TABLE_CATALOG` | `name` |
| `SCHEMA_COUNT` | `schemaCount` |

## Schemas

Atlan maps schemas from Oracle to its `Schema` asset type.

| Source property | Atlan property |
| --- | --- |
| `TABLE_SCHEMA` | `name` |
| `TABLE_COUNT` | `tableCount` |
| `VIEW_COUNT` | `viewsCount` |
| `TABLE_CATALOG` | `databaseName` |

## Tables

Atlan maps tables from Oracle to its `Table` asset type.

| Source property | Atlan property |
| --- | --- |
| `TABLE_NAME` | `name` |
| `REMARKS` | `description` |
| `COLUMN_COUNT` | `columnCount` |
| `ROW_COUNT` | `rowCount` |
| `BYTES` | `sizeBytes` |
| `TABLE_TYPE` | `subType` |
| `HAS_PARTITIONS` | `isPartitioned` |
| `PARTITION_STRATEGY` | `partitionStrategy` |
| `PARTITION_COUNT` | `partitionCount` |
| `TEMPORARY` | `isTemporary` |
| `ALIAS` | `displayName` |

## Views

Atlan maps views from Oracle to its `View` asset type.

| Source property | Atlan property |
| --- | --- |
| `TABLE_NAME` | `name` |
| `REMARKS` | `description` |
| `COLUMN_COUNT` | `columnCount` |
| `VIEW_DEFINITION` | `definition` |
| `HAS_PARTITIONS` | `isPartitioned` |
| `PARTITION_COUNT` | `partitionCount` |
| `TEMPORARY` | `isTemporary` |
| `ALIAS` | `displayName` |

## Columns

Atlan maps columns from Oracle to its `Column` asset type.

| Source property | Atlan property |
| --- | --- |
| `COLUMN_NAME` | `name` |
| `REMARKS` | `description` |
| `ORDINAL_POSITION` | `order` |
| `TYPE_NAME` | `dataType` |
| `CONSTRAINT_TYPES (PRIMARY KEY)` | `isPrimary` |
| `CONSTRAINT_TYPES (FOREIGN KEY)` | `isForeign` |
| `IS_NULLABLE` | `isNullable` |
| `NUMERIC_SCALE` | `numericScale` |
| `CHARACTER_MAXIMUM_LENGTH` | `maxLength` |

---