# Oracle Partitioning General API

**Canonical:** https://apis.io/apis/oracle-partitioning/oracle-partitioning-general-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 General 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. The published artifact set on APIs.io includes an OpenAPI specification, API documentation, and an API reference.

Services related to the Oracle database instance.

## Operations (31)

| Method | Path | Summary |
|---|---|---|
| GET | `/database/components/` | Get all database components |
| GET | `/database/components/{comp_id}` | Get a database component |
| GET | `/database/connections/` | Get a description of all local listeners for this database |
| GET | `/database/connections/{host_name},{port},{service_name}` | Get a description of a specific local listener for this database |
| POST | `/database/datapump/jobs/` | Create a data pump job |
| GET | `/database/feature_usage/` | Get all feature usage statistics |
| GET | `/database/feature_usage/{dbid},{name}` | Get usage statistic for a feature |
| GET | `/database/parameters/` | Get all database parameters |
| GET | `/database/parameters/{name}` | Get a specific database parameter |
| GET | `/database/security/users/` | Get all database users |
| GET | `/database/security/users/{username}` | Get a specific database user |
| POST | `/database/sessionless-transactions/` | Start a sessionless transaction |
| PUT | `/database/sessionless-transactions/{sessionlessTransactionID}` | Commit a sessionless transaction |
| DELETE | `/database/sessionless-transactions/{sessionlessTransactionID}` | Rollback a sessionless transaction |
| GET | `/database/status` | Get database status |
| GET | `/database/storage/bytes` | Get storage statistics |
| GET | `/database/storage/tablespaces/` | Get all tablespaces storage data |
| GET | `/database/storage/tablespaces/{tablespace_name}/` | Get storage for a specific tablespace |
| GET | `/database/storage/tablespaces/{tablespace_name}/datafiles_usage` | Get data file usage summary for a specific tablespace |
| GET | `/database/storage/tablespaces/{tablespace_name}/datafiles/` | Get data files for a tablespace |
| GET | `/database/storage/tablespaces/{tablespace_name}/datafiles/{file_id}/` | Get tablespace data file |
| GET | `/database/storage/tablespaces/{tablespace_name}/datafiles/{file_id}/usage` | Get tablespace data file usage |
| GET | `/database/storage/tablespaces/{tablespace_name}/history` | Get tablespace space usage history |
| GET | `/database/storage/tablespaces/{tablespace_name}/segments/` | Get tablespace segments |
| GET | `/database/storage/tablespaces/{tablespace_name}/segments/{segment_name}` | Get a tablespace segment |
| GET | `/database/storage/tablespaces/{tablespace_name}/tempfiles_usage` | Get temporary file usage summary for a specific tablespace |
| GET | `/database/storage/tablespaces/{tablespace_name}/tempfiles/` | Get temporary files for a tablespace |
| GET | `/database/storage/tablespaces/{tablespace_name}/tempfiles/{file_id}/` | Get tablespace temporary file |
| GET | `/database/storage/tablespaces/{tablespace_name}/tempfiles/{file_id}/usage` | Get tablespace temporary file usage |
| GET | `/database/version` | Get database version |
| GET | `/environment/homes/{homeName}/` | Get specific database Oracle Home |

## Machine-readable artifacts (5)

- **OpenAPI** — https://raw.githubusercontent.com/api-evangelist/oracle-partitioning/refs/heads/main/openapi/oracle-partitioning-general-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 Dictionary API](https://apis.io/apis/oracle-partitioning/oracle-partitioning-data-dictionary-api/)
- [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 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/)

---

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