# Oracle Partitioning Data Dictionary API

**Canonical:** https://apis.io/apis/oracle-partitioning/oracle-partitioning-data-dictionary-api/  
**Provider:** Oracle Partitioning — https://apis.io/providers/oracle-partitioning/  
**Base URL:** https://{server}/{context-root}/{database}/{schema}/_/db-api/stable  
**Documentation:** https://docs.oracle.com/en/database/oracle/oracle-rest-data-services/

Oracle Partitioning Data Dictionary API is one of 25 APIs that [Oracle Partitioning](https://apis.io/providers/oracle-partitioning/) publishes on the [APIs.io](https://apis.io/) network, described by a machine-readable OpenAPI specification. Tagged areas include Data Dictionary. The published artifact set on APIs.io includes an OpenAPI specification, API documentation, and an API reference.

Services related to the tables and views that provide information about the database.

## Operations (28)

| Method | Path | Summary |
|---|---|---|
| GET | `/database/db_links/` | Get all database links |
| GET | `/database/db_links/{owner},{db_link}` | Get a database link |
| GET | `/database/objects/` | Get all database objects |
| GET | `/database/objects/{owner},{object_name},{object_type}` | Get a specific object |
| GET | `/database/objects/arguments/` | Get all arguments for functions and procedures |
| GET | `/database/objects/arguments/{object_id},{subprogram_id},{argument_name}` | Get an argument |
| GET | `/database/objects/columns/` | Get all table columns |
| GET | `/database/objects/columns/{owner},{table_name},{column_name}` | Get a specific column |
| GET | `/database/objects/foreign_keys/` | Get all foreign keys |
| GET | `/database/objects/foreign_keys/{owner},{constraint_name}` | Get a specific foreign keys |
| GET | `/database/objects/functions/` | Get all functions |
| GET | `/database/objects/functions/{object_id}` | Get a specific function |
| GET | `/database/objects/indexes/` | Get all indexes |
| GET | `/database/objects/indexes/{owner},{index_name}` | Get a specific index |
| GET | `/database/objects/materialized_view_logs/` | Get all materialized view logs |
| GET | `/database/objects/materialized_view_logs/{log_owner},{log_table}` | Get information on a specific materialized view log |
| GET | `/database/objects/packages/procedures/` | Get all procedures defined in package |
| GET | `/database/objects/packages/procedures/{object_id},{subprogram_id}` | Get a procedure that is defined in package |
| GET | `/database/objects/partitions/` | Get all partitions in the database |
| GET | `/database/objects/partitions/{table_owner},{table_name},{partition_name}` | Get a partition |
| GET | `/database/objects/synonyms/` | Get all synonyms in the database |
| GET | `/database/objects/synonyms/{owner},{synonym_name}` | Get a synonym |
| GET | `/database/objects/tables/` | Get all tables |
| GET | `/database/objects/tables/{owner},{table_name}` | Get a specific table |
| GET | `/database/tablespaces/` | Get all tablespaces |
| GET | `/database/tablespaces/{tablespace_name}` | Get a specific tablespace |
| GET | `/database/objects/types/` | Get all object types |
| GET | `/database/objects/types/{owner},{type_name}` | Get an object type |

## Machine-readable artifacts (5)

- **OpenAPI** — https://raw.githubusercontent.com/api-evangelist/oracle-partitioning/refs/heads/main/openapi/oracle-partitioning-data-dictionary-api-openapi.yml
- **Documentation** — https://docs.oracle.com/en/database/oracle/oracle-rest-data-services/26.1/orrst/index.html
- **APIReference** — https://docs.oracle.com/en/database/oracle/oracle-rest-data-services/26.1/orrst/rest-endpoints.html
- **ErrorCatalog** — https://raw.githubusercontent.com/api-evangelist/oracle-partitioning/refs/heads/main/errors/oracle-partitioning-problem-types.yml
- **DataModel** — https://raw.githubusercontent.com/api-evangelist/oracle-partitioning/refs/heads/main/data-model/oracle-partitioning-data-model.yml

## Other Oracle Partitioning APIs (12)

- [Oracle SQL Developer REST Services - Partitioning](https://apis.io/apis/oracle-partitioning/oracle-sql-developer-rest-services-partitioning/)
- [Oracle Cloud Infrastructure Database API - Partitioning](https://apis.io/apis/oracle-partitioning/oracle-cloud-infrastructure-database-api-partitioning/)
- [Oracle Partitioning Data Guard API](https://apis.io/apis/oracle-partitioning/oracle-partitioning-data-guard-api/)
- [Oracle Partitioning Data Pump API](https://apis.io/apis/oracle-partitioning/oracle-partitioning-data-pump-api/)
- [Oracle Partitioning Data Tools API](https://apis.io/apis/oracle-partitioning/oracle-partitioning-data-tools-api/)
- [Oracle Partitioning Environment API](https://apis.io/apis/oracle-partitioning/oracle-partitioning-environment-api/)
- [Oracle Partitioning General API](https://apis.io/apis/oracle-partitioning/oracle-partitioning-general-api/)
- [Oracle Partitioning Monitoring API](https://apis.io/apis/oracle-partitioning/oracle-partitioning-monitoring-api/)
- [Oracle Partitioning Open Service Broker API](https://apis.io/apis/oracle-partitioning/oracle-partitioning-open-service-broker-api/)
- [Oracle Partitioning Oracle APEX API](https://apis.io/apis/oracle-partitioning/oracle-partitioning-oracle-apex-api/)
- [Oracle Partitioning Oracle Transactional Event Queues API](https://apis.io/apis/oracle-partitioning/oracle-partitioning-oracle-transactional-event-queues-api/)
- [Oracle Partitioning ORDS REST Services API](https://apis.io/apis/oracle-partitioning/oracle-partitioning-ords-rest-services-api/)

## Tags

Data Dictionary

---

Profiled by [API Evangelist](https://apievangelist.com) and published on [APIs.io](https://apis.io/apis/oracle-partitioning/oracle-partitioning-data-dictionary-api/). The API's provider profile, Kin Score and agent-readiness rating are at https://apis.io/providers/oracle-partitioning/.