How AI is applied across API Evangelist and APIs.io. Read my AI disclosure →
API Evangelist API Evangelist
Discovery
Learnings
Guidance
Toolbox
Alignment
API Evangelist LLC
Discovery
Learnings
Guidance
Toolbox
Alignment
API Evangelist LLC

Need help?

Contact us
Oracle Partitioning

Oracle Partitioning General API

Services related to the Oracle database instance.

Documentation Provider Profile APIs.io OpenAPI GitHub

Oracle Partitioning General API is one of 25 APIs that Oracle Partitioning publishes on the 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.

This API exposes 31 operations across 30 paths, and defines 29 schemas. It is described by OpenAPI 3.2.0, at version 2026.03.26.

Requests are made against the base URL https://{server}/{context-root}/{database}/{schema}/_/db-api/stable.

31 operations 30 paths 29 schemas 1 DELETE27 GET2 POST1 PUT

Metadata

The identity and technical contract details declared by the specification.

Specification
OpenAPI 3.2.0
API Version
2026.03.26
Base URL
https://{server}/{context-root}/{database}/{schema}/_/db-api/stable
Authentication
HTTP Basic, HTTP Bearer, OAuth 2.0
Contact
Oracle REST Data Services
Resource Areas
1

Authentication & Security 3

Oracle Partitioning General API declares 3 security schemes for authenticating requests. It accepts HTTP basic authentication (BasicAuth). It accepts HTTP bearer tokens (BearerAuth). It supports OAuth 2.0 (OAuth2) using the implicit, authorizationCode and clientCredentials flows.

Paths & Operations 31

Across 30 paths, the API surfaces 31 operations — 1 DELETE, 27 GET, 2 POST, 1 PUT. Each is listed below with its method, path, parameters, and response codes.

General 31

Services related to the Oracle database instance.

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

Schemas 29

The contract defines 29 schemas that model the data the API accepts and returns. The most detailed are DatabaseTablespaceSegmentsItem (32 properties), DatabaseUsersItem (28 properties), DatabaseStatusItem (27 properties), DatabaseVersionItem (25 properties). Each schema is shown below with its type and property counts.

DatabaseStatusItem
object
Relying on GV$INSTANCE and GV$DATABASE views this object provides information on the status of the database.
27 properties
DatabaseVersionItem
object
Relying on GV$INSTANCE and GV$VERSION views this object provides information on the version of the database.
25 properties
DatabaseTablespaceSegmentsItem
object
Describes the storage allocated for a segments in the database.
32 properties
DatabaseTablespaceSegments
object
6 properties
DataPumpJobsItem
object
This object represents a specified Data Pump job in the database.
9 properties
DatabaseUsersItem
object
This object describes a database user. The list of attributes may vary depending on database version.
28 properties
DatabaseUsers
object
6 properties
DatabaseTablespacesItem
object
Describes a tablespace in the database.
18 properties
DatabaseTablespaceTempfiles
object
6 properties
DatabaseComponents
object
DBAREGISTRY displays information about all components in the database that are loaded into the component registry. The component registry tracks components tha…
6 properties
DatabaseTablespaces
object
6 properties
DatabaseConnectionsItem
object
Information on the listeners configured for the database is retrieved from GV$LISTENERNETWORK. The list of attributes may vary depending on database version.
6 properties
DatabaseFeatureUsage
object
6 properties
DatabaseTablespaceTempfilesItem
object
Describes a temporary file in the database.
16 properties
DatabaseFeatureUsageItem
object
Statistics on the usage in the database for an Oracle Database feature.
15 properties
LinkRelation
object
2 properties 2 required
DatabaseTablespaceHistoryItem
object
Describes historical tablespace usage statistics.
11 properties
DatabaseParameters
object
6 properties
Filter
object
See Oracle REST Data Services production documentation 'Filtering in Queries' section.
DatabaseComponentsItem
object
A component registered in the database.
14 properties
DatabaseTablespaceDatafilesItem
object
15 properties
DatabaseTablespaceDatafilesUsageItem
object
Using GV$DATAFILE and DBAFREESPACE data this object represents the usage of a data file in the database.
2 properties
EnvironmentHomesItem
object
An Oracle home is a directory into which Oracle software is installed.
5 properties
DatabaseParametersItem
object
This documentation represents an initialization parameter that is currently in effect for the instance. A new session inherits parameter values from the instan…
21 properties
TransactionResponse
object
2 properties
DatabaseTablespaceDatafiles
object
6 properties
DatabaseConnections
object
Information on the listeners configured for the database is retrieved from GV$LISTENERNETWORK.
6 properties
DatabaseTablespaceDatafileUsageItem
object
Using GV$DATAFILE and DBAFREESPACE data this object represents the usage of a data file in the database.
9 properties
DatabaseStorageBytesItem
object
Total size of data files in the database and their total usage.
3 properties

Specification

The full machine-readable OpenAPI contract behind this narrative.

Source

oracle-partitioning-general-api-openapi.yml Raw ↑

Other APIs Oracle Partitioning publishes across the network.

Oracle SQL Developer REST Services - Partitioning
AE Profile APIs.io
Oracle Cloud Infrastructure Database API - Partitioning
AE Profile APIs.io
Oracle Partitioning Data Dictionary API
AE Profile APIs.io
Oracle Partitioning Data Guard API
AE Profile APIs.io
Oracle Partitioning Data Pump API
AE Profile APIs.io
Oracle Partitioning Data Tools API
AE Profile APIs.io
Oracle Partitioning Environment API
AE Profile APIs.io
Oracle Partitioning Monitoring API
AE Profile APIs.io
Oracle Partitioning Open Service Broker API
AE Profile APIs.io
Oracle Partitioning Oracle APEX API
AE Profile APIs.io
Oracle Partitioning Oracle Transactional Event Queues API
AE Profile APIs.io
Oracle Partitioning ORDS REST Services API
AE Profile APIs.io
← Back to O APIs
API Details
ID
oracle-partitioning:oracle-partitioning-general-api
Base URL
https://{server}/{context-root}/{database}/{schema}/_/db-api/stable
Docs
https://docs.oracle.com/en/database/oracle/oracle-rest-data-services/
Provider
Oracle Partitioning
APIs.io →  GitHub →
Explore more
All APIs Providers APIs.io Network
Work with this as data

Every API here is available over the API and to AI agents over MCP. APIs is not yet its own endpoint on the v1 API. Reach this content through network search and the tag graph, or the MCP server below.

Installs https://mcp.apievangelist.com/mcp in Claude, Cursor, VS Code and the rest — one button, every client.

MCP tools for apis
4 tools reach this content
  • search_api_evangelistSearch every content type across the network at once.
  • find_relatedThe shared-tag relevance graph — what else covers this.
  • get_tagEverything one tag labels, across all content types.
  • guide_topicPRO — a curated bundle for a topic: area, guidance, rules, papers, stories, services.
All tools & prompts
Call it yourself
curl for this page
Search the network for this 
curl "https://api.apievangelist.com/v1/search?q=oracle-partitioning-general-api&limit=10"
Everything under a tag 
curl "https://api.apievangelist.com/v1/tags/oracle-partitioning-general-api"

Discovery needs no key. Full bodies and the synthesis endpoints are Pro.

Get an API key

Free tier, no email required. Sign in with whichever identity you already have.

GitHub Google LinkedIn

A second provider on the same verified email joins the account you already have. Your account

Where this information came from

This is an independent, third-party profile of Oracle Partitioning General API, published by API Evangelist. We do not operate, host, resell, or support these APIs, and we are not affiliated with or endorsed by the company unless stated above. Everything here is built from publicly available information — the company's own site, developer portal, documentation, public repositories, and the specifications it publishes for public use. Nothing is obtained by breaching a system, defeating an access control, or using credentials.

The Kin Score and Agent Readiness rating are independently calculated assessments of a company's public API artifacts, scored against a published rubric. They are not certifications, endorsements, security assessments, or audits.

Corrections, re-scores, and removal are free — no partnership or purchase required, and you do not need to justify the request. A removed company is recorded as unrated, never scored zero for having asked. Acknowledgement within one business day; removal within two.

info@apievangelist.com · Read the full data-sourcing policy →
On a security or compliance team? Put security in the subject line and you will get a person, not a form — we will tell you exactly which public URLs this profile was built from.