Oracle Partitioning website screenshot

Oracle Partitioning

Oracle Partitioning is a licensed option of Oracle Database Enterprise Edition that divides large tables and indexes into smaller, independently manageable segments called partitions, accessed transparently through the table name. It delivers partition pruning (the optimizer eliminates irrelevant partitions from query plans), partition-wise parallel operations, and partition maintenance as atomic DDL — archiving or purging a partition instead of deleting rows. Strategies include range, interval, list, hash, reference, composite and auto-partitioning. It is not a standalone API product: partitions are CREATED and MAINTAINED through SQL DDL, and READ over REST through two Data Dictionary endpoints of the Oracle REST Data Services (ORDS) Database API, which is the machine-readable contract captured in this repository.

Oracle Partitioning publishes 23 APIs on the APIs.io network, including Data Dictionary API, Data Guard API, Data Pump API, and 20 more. Tagged areas include Agent Skills, Composite-Partitioning, Data Dictionary, Database, and Enterprise Edition Option.

Oracle Partitioning’s developer surface includes CLI, sandbox, changelog, authentication, documentation, API reference, getting-started guide, and 32 more developer resources.

🌐 Visit website 📡 Source on GitHub
58.6/100 strong ▬ flat Agent 42/100 agent ready saas Full breakdown ↓
scored 2026-09-14 · rubric v0.22.0
AccessFreemium
1 APIs 1 MCP Servers
Agent SkillsComposite-PartitioningData DictionaryDatabaseEnterprise Edition OptionHash-PartitioningInterval-PartitioningList-PartitioningMCPORDSOracleOracle DatabasePartitioningPerformanceRange-PartitioningSQLScalabilityTable PartitioningVLDB

Kin Score

Kin Score Kin Score How this is scored →
scored 2026-09-14 · rubric v0.22.0
Composite quality — 58.6/100 · strong
Contract Quality 10.2 / 23
Developer Ergonomics 15.0 / 18
Access Clarity 12.3 / 18
Operational Transparency 6.2 / 12
Contract Governance 0.5 / 11
Discoverability 6.2 / 9
Create-or-Update Ergonomics 3.3 / 10
Agent readiness — 42/100 · agent ready
Machine-Readable Contract 18 / 18
Agentic Access Contract 0 / 10
Documented Reversibility 6 / 6
MCP Server 12 / 12
Machine-Readable Auth 10 / 10
Idempotency 0 / 9
Stable Error Semantics 8 / 8
Request/Response Examples 7 / 7
Rate-Limit Signaling 7 / 7
Typed Event Surface 0 / 6
Agent Skills 5 / 5
Well-Known Catalog 0 / 4
Consent & Bot Identity 0 / 3
A2A Agent Card 0 / 8
Dry-Run / Simulate Mode 4 / 4
Delegated User Identity 6 / 6
Protected Resource Metadata 0 / 5
Registration Without a Human 0 / 6
Agentic Commerce Well-Known Document 0 / 5
Create-or-Update Ergonomics applies to this provider. This API accepts writes, so it carries 10 points of the composite. It is scored from the published contracts themselves: whether a caller can create-or-update in one call, whether the write accepts a key the caller already holds, and whether the response says which branch ran. Without that, every write needs a search-and-branch in front of it, and the first time that check is skipped a duplicate record is created. Scored against the observed mean rather than raw — a provider at the catalog average is unchanged by this facet, not penalised by it.
Improve this rating by publishing the missing artifacts — every area above can be raised, and the full rubric is at apis.io/rating/. Every facet and dimension name above is a link: it opens that measurement's own page — what it means, the exact checks that feed it, how the whole catalog distributes on it, and the providers at the top of it. This rating is computed from github.com/api-evangelist/oracle-partitioning: open an issue to ask a question, or submit a pull request to add artifacts. Submit an artifact on GitHub — free → Manage your own listing — the Influence plan, $499/mo →

APIs 25

Individual APIs this provider publishes, each with its own machine-readable definition.

Oracle SQL Developer REST Services - Partitioning

Oracle SQL Developer Web and SQLcl, the SQL surfaces through which partitions are actually created and maintained. Partition DDL — CREATE TABLE ... PARTITION BY, ALTER TABLE ......

Oracle Cloud Infrastructure Database API - Partitioning

The Oracle Cloud Infrastructure Database API, which manages the DB systems, Autonomous Databases and Exadata infrastructure that host partitioned databases. It manages the datab...

Oracle Partitioning Data Dictionary API

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

Oracle Partitioning Data Guard API

Services related to Oracle Data Guard. The product must be installed in the Oracle database that ORDS is configured to use.

Oracle Partitioning Data Pump API

Services related to Oracle Data Pump. Oracle Data Pump technology enables very high-speed movement of data and metadata from one database to another. Functionality may differ de...

Oracle Partitioning Data Tools API

Services related to loading, manipulating and analyzing data.

Oracle Partitioning Environment API

Services related to the Oracle database installation. The implementation is only available for Unix based operating systems.

Oracle Partitioning General API

Services related to the Oracle database instance.

Oracle Partitioning Monitoring API

Services related to monitoring the Oracle database instance.

Oracle Partitioning Open Service Broker API

Services related to the Open Service Broker compliant implementation that ORDS provides.

Oracle Partitioning Oracle APEX API

Services related to Oracle APEX. The product must be installed in the Oracle database that ORDS is configured to use.

Oracle Partitioning Oracle Transactional Event Queues API

Services related to Oracle Transactional Event Queues.

Oracle Partitioning ORDS REST Services API

Custom Oracle REST Data Services built with SQL & PL/SQL.

Oracle Partitioning Performance API

Services related to the runtime performance of the Oracle database instance.

Oracle Partitioning Pluggable Database Lifecycle Management API

Services related to managing pluggable databases in an Oracle multitenant database instance.

Oracle Partitioning Pluggable Database Snapshot Carousel API

Services related to managing pluggable databases snapshots in an Oracle database instance.

Oracle Partitioning RDF Graph API

Services related to Oracle RDF Graph. Oracle RDF Graph provides functionality to manage knowledge graphs based on World Wide Web Consortium (W3C) standards such as RDF, OWL and ...

Oracle Partitioning Scheduler API

Oracle Scheduler, an enterprise job scheduler to help you simplify the scheduling of hundreds or even thousands of tasks. Oracle Scheduler (the Scheduler) is implemented by the ...

Oracle Partitioning Vector Database/Inference Operations API

The operations from the Vector Database/Inference Operations category.

Oracle Partitioning Vector Database/Models API

The operations from the Vector Database/Models category.

Oracle Partitioning Vector Database/Summary API

The operations from the Vector Database/Summary category.

Oracle Partitioning Vector Database/Vector Indexes API

The operations from the Vector Database/Vector Indexes category.

Oracle Partitioning Vector Database/Vector Operations API

The operations from the Vector Database/Vector Operations category.

Oracle Partitioning Vector Database/Vector Search API

The operations from the Vector Database/Vector Search category.

Oracle Partitioning Vector Database/Vector Tables API

The operations from the Vector Database/Vector Tables category.

Scroll for all 25

MCP Servers 1

Model Context Protocol servers that expose these APIs to AI agents.

Oracle AI Database MCP Servers

Oracle publishes three first-party MCP servers for Oracle AI Database, all of which reach partitioned tables the same way a DBA does — by executing SQL against the database. The...

MCP SERVER

Pricing Plans 1

Published pricing tiers and plan structures.

Oracle Partitioning Plans Pricing

2 plans

PLANS

Rate Limits 1

Documented rate limits and quota policies.

Oracle Partitioning Rate Limits

0 limits

RATE LIMITS

FinOps 1

Cost, billing, and metering signals for API financial operations.

Oracle Partitioning Finops

FINOPS

Security Posture 3

Authentication, domain security, vulnerability disclosure, and trust-center signals.

Oracle Partitioning Authentication

http/oauth2 · 3 schemes

SECURITY

Oracle Partitioning Domain Security

TLSv1.3 · HSTS · DMARC

SECURITY

Oracle Partitioning Vulnerability Disclosure

Hackerone

SECURITY

Scopes 1

OAuth scopes governing access to this provider's APIs.

Oracle Partitioning Scopes

OAuth 2.0 · no documented scopes

0 scopes

SCOPES

Resources

Get Started 4

Portal, sign-up, and the first successful call

Sandbox
Sandbox
 DeveloperPortal
DeveloperPortal
 GettingStarted
GettingStarted
 SignUp
SignUp

Documentation 3

Reference material describing how the API behaves

OpenAPI
OpenAPI
 Documentation
Documentation
 APIReference
APIReference

Agent Surfaces 3

MCP servers, agent skills, and machine-readable catalogs

MCPServer
MCPServer
 AgentSkill
AgentSkill
 LLMsTxt
LLMsTxt

Design & Contract 5

Pagination, idempotency, versioning, errors, and events

Conventions
Conventions
 ErrorCatalog
ErrorCatalog
 DataModel
DataModel
 Conformance
Conformance
 Lifecycle
Lifecycle

Build 5

SDKs, sample code, and the tooling you integrate with

ToolCrosswalk
ToolCrosswalk
 Packages
Packages
 SDKs
SDKs
 CLI
CLI
 GitHubOrganization
GitHubOrganization

Access & Security 6

Authentication, authorization, and security posture

Authentication
Authentication
 OAuthScopes
OAuthScopes
 DomainSecurity
DomainSecurity
 VulnerabilityDisclosure
VulnerabilityDisclosure
 Security
Security
 Compliance
Compliance

Operate 5

Status, limits, changes, and where to get help

ChangeLog
ChangeLog
 Deprecation
Deprecation
 StatusPage
StatusPage
 RateLimits
RateLimits
 Support
Support

Commercial 5

Pricing, plans, and the legal terms of use

Plans
Plans
 FinOps
FinOps
 Pricing
Pricing
 TermsOfService
TermsOfService
 PrivacyPolicy
PrivacyPolicy

Company 1

The organization behind the API

Website
Website

Other 2

Properties that don't map to a standard resource type

Overlay
Overlay
 White Papers
White Papers

Source (apis.yml)

apis.yml Raw ↑ 
aid: oracle-partitioning
name: Oracle Partitioning
description: 'Oracle Partitioning is a licensed option of Oracle Database Enterprise Edition that divides large tables and
  indexes into smaller, independently manageable segments called partitions, accessed transparently through the table name.
  It delivers partition pruning (the optimizer eliminates irrelevant partitions from query plans), partition-wise parallel
  operations, and partition maintenance as atomic DDL — archiving or purging a partition instead of deleting rows. Strategies
  include range, interval, list, hash, reference, composite and auto-partitioning. It is not a standalone API product: partitions
  are CREATED and MAINTAINED through SQL DDL, and READ over REST through two Data Dictionary endpoints of the Oracle REST
  Data Services (ORDS) Database API, which is the machine-readable contract captured in this repository.'
type: Index
deliveryModel:
  model: saas
  open_source: false
  commercial: true
  callable_host: false
  label: Hosted service · you call their endpoint
  confidence: medium
  source:
  - pricing
  generated: '2026-08-28'
  method: derived
accessModel:
  pricing: freemium
  onboarding: unknown
  trial: false
  try_now: false
  public: false
  label: Freemium
  confidence: medium
  source:
  - plans
  generated: '2026-07-22'
  method: derived
position: Consuming
access: 3rd-Party
image: https://kinlane-images.s3.amazonaws.com/shared/apis-json/icons/oracle-partitioning.png
url: https://raw.githubusercontent.com/api-evangelist/oracle-partitioning/refs/heads/main/apis.yml
created: '2024-01-01'
modified: '2026-08-27'
specificationVersion: '0.23'
apis:
- name: Oracle SQL Developer REST Services - Partitioning
  description: Oracle SQL Developer Web and SQLcl, the SQL surfaces through which partitions are actually created and maintained.
    Partition DDL — CREATE TABLE ... PARTITION BY, ALTER TABLE ... SPLIT/MERGE/EXCHANGE/DROP PARTITION — has no REST operation
    in any Oracle contract and is issued here.
  image: https://www.oracle.com/a/ocom/img/sql-dev.jpg
  baseURL: https://{server}/{context-root}
  humanURL: https://www.oracle.com/database/sqldeveloper/
  properties:
  - type: Documentation
    url: https://docs.oracle.com/en/database/oracle/sql-developer/
  - type: CLI
    url: cli/oracle-partitioning-cli.yml
  - type: Tutorial
    url: https://docs.oracle.com/en/database/oracle/oracle-database/19/vldbg/partition-admin.html
- name: Oracle Cloud Infrastructure Database API - Partitioning
  description: The Oracle Cloud Infrastructure Database API, which manages the DB systems, Autonomous Databases and Exadata
    infrastructure that host partitioned databases. It manages the database service, not individual partitions.
  image: https://www.oracle.com/a/ocom/img/oci-logo.png
  baseURL: https://database.{region}.oraclecloud.com
  humanURL: https://www.oracle.com/cloud/
  properties:
  - type: Documentation
    url: https://docs.oracle.com/en-us/iaas/api/
  - type: SDKs
    url: https://docs.oracle.com/en-us/iaas/Content/API/Concepts/sdks.htm
  contact:
  - FN: Oracle Cloud Support
    email: cloud-support@oracle.com
    url: https://www.oracle.com/support/
- aid: oracle-partitioning:oracle-partitioning-data-dictionary-api
  name: Oracle Partitioning Data Dictionary API
  description: Services related to the tables and views that provide information about the database.
  humanURL: https://docs.oracle.com/en/database/oracle/oracle-rest-data-services/
  baseURL: https://{server}/{context-root}/{database}/{schema}/_/db-api/stable
  tags:
  - Data Dictionary
  properties:
  - type: OpenAPI
    url: openapi/oracle-partitioning-data-dictionary-api-openapi.yml
  - type: Documentation
    url: https://docs.oracle.com/en/database/oracle/oracle-rest-data-services/26.1/orrst/index.html
  - type: APIReference
    url: https://docs.oracle.com/en/database/oracle/oracle-rest-data-services/26.1/orrst/rest-endpoints.html
  - type: ErrorCatalog
    url: errors/oracle-partitioning-problem-types.yml
  - type: DataModel
    url: data-model/oracle-partitioning-data-model.yml
- aid: oracle-partitioning:oracle-partitioning-data-guard-api
  name: Oracle Partitioning Data Guard API
  description: Services related to Oracle Data Guard. The product must be installed in the Oracle database that ORDS is configured
    to use.
  humanURL: https://docs.oracle.com/en/database/oracle/oracle-rest-data-services/
  baseURL: https://{server}/{context-root}/{database}/{schema}/_/db-api/stable
  tags:
  - Data Guard
  properties:
  - type: OpenAPI
    url: openapi/oracle-partitioning-data-guard-api-openapi.yml
  - type: Documentation
    url: https://docs.oracle.com/en/database/oracle/oracle-rest-data-services/26.1/orrst/index.html
  - type: APIReference
    url: https://docs.oracle.com/en/database/oracle/oracle-rest-data-services/26.1/orrst/rest-endpoints.html
  - type: ErrorCatalog
    url: errors/oracle-partitioning-problem-types.yml
  - type: DataModel
    url: data-model/oracle-partitioning-data-model.yml
- aid: oracle-partitioning:oracle-partitioning-data-pump-api
  name: Oracle Partitioning Data Pump API
  description: Services related to Oracle Data Pump. Oracle Data Pump technology enables very high-speed movement of data
    and metadata from one database to another. Functionality may differ depending on the configuration and permissions the
    database user has.
  humanURL: https://docs.oracle.com/en/database/oracle/oracle-rest-data-services/
  baseURL: https://{server}/{context-root}/{database}/{schema}/_/db-api/stable
  tags:
  - Data Pump
  properties:
  - type: OpenAPI
    url: openapi/oracle-partitioning-data-pump-api-openapi.yml
  - type: Documentation
    url: https://docs.oracle.com/en/database/oracle/oracle-rest-data-services/26.1/orrst/index.html
  - type: APIReference
    url: https://docs.oracle.com/en/database/oracle/oracle-rest-data-services/26.1/orrst/rest-endpoints.html
  - type: ErrorCatalog
    url: errors/oracle-partitioning-problem-types.yml
  - type: DataModel
    url: data-model/oracle-partitioning-data-model.yml
- aid: oracle-partitioning:oracle-partitioning-data-tools-api
  name: Oracle Partitioning Data Tools API
  description: Services related to loading, manipulating and analyzing data.
  humanURL: https://docs.oracle.com/en/database/oracle/oracle-rest-data-services/
  baseURL: https://{server}/{context-root}/{database}/{schema}/_/db-api/stable
  tags:
  - Data Tools
  properties:
  - type: OpenAPI
    url: openapi/oracle-partitioning-data-tools-api-openapi.yml
  - type: Documentation
    url: https://docs.oracle.com/en/database/oracle/oracle-rest-data-services/26.1/orrst/index.html
  - type: APIReference
    url: https://docs.oracle.com/en/database/oracle/oracle-rest-data-services/26.1/orrst/rest-endpoints.html
  - type: ErrorCatalog
    url: errors/oracle-partitioning-problem-types.yml
  - type: DataModel
    url: data-model/oracle-partitioning-data-model.yml
- aid: oracle-partitioning:oracle-partitioning-environment-api
  name: Oracle Partitioning Environment API
  description: Services related to the Oracle database installation. The implementation is only available for Unix based operating
    systems.
  humanURL: https://docs.oracle.com/en/database/oracle/oracle-rest-data-services/
  baseURL: https://{server}/{context-root}/{database}/{schema}/_/db-api/stable
  tags:
  - Environment
  properties:
  - type: OpenAPI
    url: openapi/oracle-partitioning-environment-api-openapi.yml
  - type: Documentation
    url: https://docs.oracle.com/en/database/oracle/oracle-rest-data-services/26.1/orrst/index.html
  - type: APIReference
    url: https://docs.oracle.com/en/database/oracle/oracle-rest-data-services/26.1/orrst/rest-endpoints.html
  - type: ErrorCatalog
    url: errors/oracle-partitioning-problem-types.yml
  - type: DataModel
    url: data-model/oracle-partitioning-data-model.yml
- aid: oracle-partitioning:oracle-partitioning-general-api
  name: Oracle Partitioning General API
  description: Services related to the Oracle database instance.
  humanURL: https://docs.oracle.com/en/database/oracle/oracle-rest-data-services/
  baseURL: https://{server}/{context-root}/{database}/{schema}/_/db-api/stable
  tags: []
  tags_raw:
  - General
  properties:
  - type: OpenAPI
    url: openapi/oracle-partitioning-general-api-openapi.yml
  - type: Documentation
    url: https://docs.oracle.com/en/database/oracle/oracle-rest-data-services/26.1/orrst/index.html
  - type: APIReference
    url: https://docs.oracle.com/en/database/oracle/oracle-rest-data-services/26.1/orrst/rest-endpoints.html
  - type: ErrorCatalog
    url: errors/oracle-partitioning-problem-types.yml
  - type: DataModel
    url: data-model/oracle-partitioning-data-model.yml
- aid: oracle-partitioning:oracle-partitioning-monitoring-api
  name: Oracle Partitioning Monitoring API
  description: Services related to monitoring the Oracle database instance.
  humanURL: https://docs.oracle.com/en/database/oracle/oracle-rest-data-services/
  baseURL: https://{server}/{context-root}/{database}/{schema}/_/db-api/stable
  tags:
  - Monitoring
  properties:
  - type: OpenAPI
    url: openapi/oracle-partitioning-monitoring-api-openapi.yml
  - type: Documentation
    url: https://docs.oracle.com/en/database/oracle/oracle-rest-data-services/26.1/orrst/index.html
  - type: APIReference
    url: https://docs.oracle.com/en/database/oracle/oracle-rest-data-services/26.1/orrst/rest-endpoints.html
  - type: ErrorCatalog
    url: errors/oracle-partitioning-problem-types.yml
  - type: DataModel
    url: data-model/oracle-partitioning-data-model.yml
- aid: oracle-partitioning:oracle-partitioning-open-service-broker-api
  name: Oracle Partitioning Open Service Broker API
  description: Services related to the Open Service Broker compliant implementation that ORDS provides.
  humanURL: https://docs.oracle.com/en/database/oracle/oracle-rest-data-services/
  baseURL: https://{server}/{context-root}/{database}/{schema}/_/db-api/stable
  tags:
  - Open Service Broker
  properties:
  - type: OpenAPI
    url: openapi/oracle-partitioning-open-service-broker-api-openapi.yml
  - type: Documentation
    url: https://docs.oracle.com/en/database/oracle/oracle-rest-data-services/26.1/orrst/index.html
  - type: APIReference
    url: https://docs.oracle.com/en/database/oracle/oracle-rest-data-services/26.1/orrst/rest-endpoints.html
  - type: ErrorCatalog
    url: errors/oracle-partitioning-problem-types.yml
  - type: DataModel
    url: data-model/oracle-partitioning-data-model.yml
- aid: oracle-partitioning:oracle-partitioning-oracle-apex-api
  name: Oracle Partitioning Oracle APEX API
  description: Services related to Oracle APEX. The product must be installed in the Oracle database that ORDS is configured
    to use.
  humanURL: https://docs.oracle.com/en/database/oracle/oracle-rest-data-services/
  baseURL: https://{server}/{context-root}/{database}/{schema}/_/db-api/stable
  tags:
  - Oracle APEX
  properties:
  - type: OpenAPI
    url: openapi/oracle-partitioning-oracle-apex-api-openapi.yml
  - type: Documentation
    url: https://docs.oracle.com/en/database/oracle/oracle-rest-data-services/26.1/orrst/index.html
  - type: APIReference
    url: https://docs.oracle.com/en/database/oracle/oracle-rest-data-services/26.1/orrst/rest-endpoints.html
  - type: ErrorCatalog
    url: errors/oracle-partitioning-problem-types.yml
  - type: DataModel
    url: data-model/oracle-partitioning-data-model.yml
- aid: oracle-partitioning:oracle-partitioning-oracle-transactional-event-queues-api
  name: Oracle Partitioning Oracle Transactional Event Queues API
  description: Services related to Oracle Transactional Event Queues.
  humanURL: https://docs.oracle.com/en/database/oracle/oracle-rest-data-services/
  baseURL: https://{server}/{context-root}/{database}/{schema}/_/db-api/stable
  tags:
  - Oracle Transactional Event Queues
  properties:
  - type: OpenAPI
    url: openapi/oracle-partitioning-oracle-transactional-event-queues-api-openapi.yml
  - type: Documentation
    url: https://docs.oracle.com/en/database/oracle/oracle-rest-data-services/26.1/orrst/index.html
  - type: APIReference
    url: https://docs.oracle.com/en/database/oracle/oracle-rest-data-services/26.1/orrst/rest-endpoints.html
  - type: ErrorCatalog
    url: errors/oracle-partitioning-problem-types.yml
  - type: DataModel
    url: data-model/oracle-partitioning-data-model.yml
- aid: oracle-partitioning:oracle-partitioning-ords-rest-services-api
  name: Oracle Partitioning ORDS REST Services API
  description: Custom Oracle REST Data Services built with SQL & PL/SQL.
  humanURL: https://docs.oracle.com/en/database/oracle/oracle-rest-data-services/
  baseURL: https://{server}/{context-root}/{database}/{schema}/_/db-api/stable
  tags:
  - ORDS REST Services
  properties:
  - type: OpenAPI
    url: openapi/oracle-partitioning-ords-rest-services-api-openapi.yml
  - type: Documentation
    url: https://docs.oracle.com/en/database/oracle/oracle-rest-data-services/26.1/orrst/index.html
  - type: APIReference
    url: https://docs.oracle.com/en/database/oracle/oracle-rest-data-services/26.1/orrst/rest-endpoints.html
  - type: ErrorCatalog
    url: errors/oracle-partitioning-problem-types.yml
  - type: DataModel
    url: data-model/oracle-partitioning-data-model.yml
- aid: oracle-partitioning:oracle-partitioning-performance-api
  name: Oracle Partitioning Performance API
  description: Services related to the runtime performance of the Oracle database instance.
  humanURL: https://docs.oracle.com/en/database/oracle/oracle-rest-data-services/
  baseURL: https://{server}/{context-root}/{database}/{schema}/_/db-api/stable
  tags:
  - Performance
  properties:
  - type: OpenAPI
    url: openapi/oracle-partitioning-performance-api-openapi.yml
  - type: Documentation
    url: https://docs.oracle.com/en/database/oracle/oracle-rest-data-services/26.1/orrst/index.html
  - type: APIReference
    url: https://docs.oracle.com/en/database/oracle/oracle-rest-data-services/26.1/orrst/rest-endpoints.html
  - type: ErrorCatalog
    url: errors/oracle-partitioning-problem-types.yml
  - type: DataModel
    url: data-model/oracle-partitioning-data-model.yml
- aid: oracle-partitioning:oracle-partitioning-pluggable-database-lifecycle-management-api
  name: Oracle Partitioning Pluggable Database Lifecycle Management API
  description: Services related to managing pluggable databases in an Oracle multitenant database instance.
  humanURL: https://docs.oracle.com/en/database/oracle/oracle-rest-data-services/
  baseURL: https://{server}/{context-root}/{database}/{schema}/_/db-api/stable
  tags:
  - Pluggable Database Lifecycle Management
  properties:
  - type: OpenAPI
    url: openapi/oracle-partitioning-pluggable-database-lifecycle-management-api-openapi.yml
  - type: Documentation
    url: https://docs.oracle.com/en/database/oracle/oracle-rest-data-services/26.1/orrst/index.html
  - type: APIReference
    url: https://docs.oracle.com/en/database/oracle/oracle-rest-data-services/26.1/orrst/rest-endpoints.html
  - type: ErrorCatalog
    url: errors/oracle-partitioning-problem-types.yml
  - type: DataModel
    url: data-model/oracle-partitioning-data-model.yml
- aid: oracle-partitioning:oracle-partitioning-pluggable-database-snapshot-carousel-api
  name: Oracle Partitioning Pluggable Database Snapshot Carousel API
  description: Services related to managing pluggable databases snapshots in an Oracle database instance.
  humanURL: https://docs.oracle.com/en/database/oracle/oracle-rest-data-services/
  baseURL: https://{server}/{context-root}/{database}/{schema}/_/db-api/stable
  tags:
  - Pluggable Database Snapshot Carousel
  properties:
  - type: OpenAPI
    url: openapi/oracle-partitioning-pluggable-database-snapshot-carousel-api-openapi.yml
  - type: Documentation
    url: https://docs.oracle.com/en/database/oracle/oracle-rest-data-services/26.1/orrst/index.html
  - type: APIReference
    url: https://docs.oracle.com/en/database/oracle/oracle-rest-data-services/26.1/orrst/rest-endpoints.html
  - type: ErrorCatalog
    url: errors/oracle-partitioning-problem-types.yml
  - type: DataModel
    url: data-model/oracle-partitioning-data-model.yml
- aid: oracle-partitioning:oracle-partitioning-rdf-graph-api
  name: Oracle Partitioning RDF Graph API
  description: Services related to Oracle RDF Graph. Oracle RDF Graph provides functionality to manage knowledge graphs based
    on World Wide Web Consortium (W3C) standards such as RDF, OWL and SPARQL.
  humanURL: https://docs.oracle.com/en/database/oracle/oracle-rest-data-services/
  baseURL: https://{server}/{context-root}/{database}/{schema}/_/db-api/stable
  tags:
  - RDF Graph
  properties:
  - type: OpenAPI
    url: openapi/oracle-partitioning-rdf-graph-api-openapi.yml
  - type: Documentation
    url: https://docs.oracle.com/en/database/oracle/oracle-rest-data-services/26.1/orrst/index.html
  - type: APIReference
    url: https://docs.oracle.com/en/database/oracle/oracle-rest-data-services/26.1/orrst/rest-endpoints.html
  - type: ErrorCatalog
    url: errors/oracle-partitioning-problem-types.yml
  - type: DataModel
    url: data-model/oracle-partitioning-data-model.yml
- aid: oracle-partitioning:oracle-partitioning-scheduler-api
  name: Oracle Partitioning Scheduler API
  description: Oracle Scheduler, an enterprise job scheduler to help you simplify the scheduling of hundreds or even thousands
    of tasks. Oracle Scheduler (the Scheduler) is implemented by the procedures and functions in the DBMS_SCHEDULER PL/SQL
    package.
  humanURL: https://docs.oracle.com/en/database/oracle/oracle-rest-data-services/
  baseURL: https://{server}/{context-root}/{database}/{schema}/_/db-api/stable
  tags:
  - Scheduler
  properties:
  - type: OpenAPI
    url: openapi/oracle-partitioning-scheduler-api-openapi.yml
  - type: Documentation
    url: https://docs.oracle.com/en/database/oracle/oracle-rest-data-services/26.1/orrst/index.html
  - type: APIReference
    url: https://docs.oracle.com/en/database/oracle/oracle-rest-data-services/26.1/orrst/rest-endpoints.html
  - type: ErrorCatalog
    url: errors/oracle-partitioning-problem-types.yml
  - type: DataModel
    url: data-model/oracle-partitioning-data-model.yml
- aid: oracle-partitioning:oracle-partitioning-vector-database-inference-operations-api
  name: Oracle Partitioning Vector Database/Inference Operations API
  description: The operations from the Vector Database/Inference Operations category.
  humanURL: https://docs.oracle.com/en/database/oracle/oracle-rest-data-services/
  baseURL: https://{server}/{context-root}/{database}/{schema}/_/db-api/stable
  tags:
  - Vector Database/Inference Operations
  properties:
  - type: OpenAPI
    url: openapi/oracle-partitioning-vector-database-inference-operations-api-openapi.yml
  - type: Documentation
    url: https://docs.oracle.com/en/database/oracle/oracle-rest-data-services/26.1/orrst/index.html
  - type: APIReference
    url: https://docs.oracle.com/en/database/oracle/oracle-rest-data-services/26.1/orrst/rest-endpoints.html
  - type: ErrorCatalog
    url: errors/oracle-partitioning-problem-types.yml
  - type: DataModel
    url: data-model/oracle-partitioning-data-model.yml
- aid: oracle-partitioning:oracle-partitioning-vector-database-models-api
  name: Oracle Partitioning Vector Database/Models API
  description: The operations from the Vector Database/Models category.
  humanURL: https://docs.oracle.com/en/database/oracle/oracle-rest-data-services/
  baseURL: https://{server}/{context-root}/{database}/{schema}/_/db-api/stable
  tags:
  - Vector Database/Models
  properties:
  - type: OpenAPI
    url: openapi/oracle-partitioning-vector-database-models-api-openapi.yml
  - type: Documentation
    url: https://docs.oracle.com/en/database/oracle/oracle-rest-data-services/26.1/orrst/index.html
  - type: APIReference
    url: https://docs.oracle.com/en/database/oracle/oracle-rest-data-services/26.1/orrst/rest-endpoints.html
  - type: ErrorCatalog
    url: errors/oracle-partitioning-problem-types.yml
  - type: DataModel
    url: data-model/oracle-partitioning-data-model.yml
- aid: oracle-partitioning:oracle-partitioning-vector-database-summary-api
  name: Oracle Partitioning Vector Database/Summary API
  description: The operations from the Vector Database/Summary category.
  humanURL: https://docs.oracle.com/en/database/oracle/oracle-rest-data-services/
  baseURL: https://{server}/{context-root}/{database}/{schema}/_/db-api/stable
  tags:
  - Vector Database/Summary
  properties:
  - type: OpenAPI
    url: openapi/oracle-partitioning-vector-database-summary-api-openapi.yml
  - type: Documentation
    url: https://docs.oracle.com/en/database/oracle/oracle-rest-data-services/26.1/orrst/index.html
  - type: APIReference
    url: https://docs.oracle.com/en/database/oracle/oracle-rest-data-services/26.1/orrst/rest-endpoints.html
  - type: ErrorCatalog
    url: errors/oracle-partitioning-problem-types.yml
  - type: DataModel
    url: data-model/oracle-partitioning-data-model.yml
- aid: oracle-partitioning:oracle-partitioning-vector-database-vector-indexes-api
  name: Oracle Partitioning Vector Database/Vector Indexes API
  description: The operations from the Vector Database/Vector Indexes category.
  humanURL: https://docs.oracle.com/en/database/oracle/oracle-rest-data-services/
  baseURL: https://{server}/{context-root}/{database}/{schema}/_/db-api/stable
  tags:
  - Vector Database/Vector Indexes
  properties:
  - type: OpenAPI
    url: openapi/oracle-partitioning-vector-database-vector-indexes-api-openapi.yml
  - type: Documentation
    url: https://docs.oracle.com/en/database/oracle/oracle-rest-data-services/26.1/orrst/index.html
  - type: APIReference
    url: https://docs.oracle.com/en/database/oracle/oracle-rest-data-services/26.1/orrst/rest-endpoints.html
  - type: ErrorCatalog
    url: errors/oracle-partitioning-problem-types.yml
  - type: DataModel
    url: data-model/oracle-partitioning-data-model.yml
- aid: oracle-partitioning:oracle-partitioning-vector-database-vector-operations-api
  name: Oracle Partitioning Vector Database/Vector Operations API
  description: The operations from the Vector Database/Vector Operations category.
  humanURL: https://docs.oracle.com/en/database/oracle/oracle-rest-data-services/
  baseURL: https://{server}/{context-root}/{database}/{schema}/_/db-api/stable
  tags:
  - Vector Database/Vector Operations
  properties:
  - type: OpenAPI
    url: openapi/oracle-partitioning-vector-database-vector-operations-api-openapi.yml
  - type: Documentation
    url: https://docs.oracle.com/en/database/oracle/oracle-rest-data-services/26.1/orrst/index.html
  - type: APIReference
    url: https://docs.oracle.com/en/database/oracle/oracle-rest-data-services/26.1/orrst/rest-endpoints.html
  - type: ErrorCatalog
    url: errors/oracle-partitioning-problem-types.yml
  - type: DataModel
    url: data-model/oracle-partitioning-data-model.yml
- aid: oracle-partitioning:oracle-partitioning-vector-database-vector-search-api
  name: Oracle Partitioning Vector Database/Vector Search API
  description: The operations from the Vector Database/Vector Search category.
  humanURL: https://docs.oracle.com/en/database/oracle/oracle-rest-data-services/
  baseURL: https://{server}/{context-root}/{database}/{schema}/_/db-api/stable
  tags:
  - Vector Database/Vector Search
  properties:
  - type: OpenAPI
    url: openapi/oracle-partitioning-vector-database-vector-search-api-openapi.yml
  - type: Documentation
    url: https://docs.oracle.com/en/database/oracle/oracle-rest-data-services/26.1/orrst/index.html
  - type: APIReference
    url: https://docs.oracle.com/en/database/oracle/oracle-rest-data-services/26.1/orrst/rest-endpoints.html
  - type: ErrorCatalog
    url: errors/oracle-partitioning-problem-types.yml
  - type: DataModel
    url: data-model/oracle-partitioning-data-model.yml
- aid: oracle-partitioning:oracle-partitioning-vector-database-vector-tables-api
  name: Oracle Partitioning Vector Database/Vector Tables API
  description: The operations from the Vector Database/Vector Tables category.
  humanURL: https://docs.oracle.com/en/database/oracle/oracle-rest-data-services/
  baseURL: https://{server}/{context-root}/{database}/{schema}/_/db-api/stable
  tags:
  - Vector Database/Vector Tables
  properties:
  - type: OpenAPI
    url: openapi/oracle-partitioning-vector-database-vector-tables-api-openapi.yml
  - type: Documentation
    url: https://docs.oracle.com/en/database/oracle/oracle-rest-data-services/26.1/orrst/index.html
  - type: APIReference
    url: https://docs.oracle.com/en/database/oracle/oracle-rest-data-services/26.1/orrst/rest-endpoints.html
  - type: ErrorCatalog
    url: errors/oracle-partitioning-problem-types.yml
  - type: DataModel
    url: data-model/oracle-partitioning-data-model.yml
common:
- type: Website
  url: https://www.oracle.com/database/technologies/partitioning.html
- type: OpenAPI
  url: openapi/oracle-partitioning-ords-database-api-openapi.json
- type: Overlay
  url: overlays/oracle-partitioning-ords-database-api-overlay.yaml
- type: MCPServer
  url: mcp/oracle-partitioning-mcp.yml
- type: ToolCrosswalk
  url: mcp/oracle-partitioning-tool-crosswalk.yml
- type: AgentSkill
  url: skills/_index.yml
- type: LLMsTxt
  url: llms/oracle-partitioning-llms.txt
- type: Packages
  url: packages/oracle-partitioning-packages.yml
- type: SDKs
  url: packages/oracle-partitioning-packages.yml
- type: CLI
  url: cli/oracle-partitioning-cli.yml
- type: Sandbox
  url: sandbox/oracle-partitioning-sandbox.yml
- type: Conventions
  url: conventions/oracle-partitioning-conventions.yml
- type: ErrorCatalog
  url: errors/oracle-partitioning-problem-types.yml
- type: DataModel
  url: data-model/oracle-partitioning-data-model.yml
- type: Conformance
  url: conformance/oracle-partitioning-conformance.yml
- type: Lifecycle
  url: lifecycle/oracle-partitioning-lifecycle.yml
- type: ChangeLog
  url: changelog/oracle-partitioning-changelog.yml
- type: Deprecation
  url: lifecycle/oracle-partitioning-lifecycle.yml
- type: StatusPage
  url: https://ocistatus.oraclecloud.com/
- type: Plans
  url: plans/oracle-partitioning-plans-pricing.yml
- type: RateLimits
  url: rate-limits/oracle-partitioning-rate-limits.yml
- type: FinOps
  url: finops/oracle-partitioning-finops.yml
- type: Authentication
  url: authentication/oracle-partitioning-authentication.yml
- type: OAuthScopes
  url: scopes/oracle-partitioning-scopes.yml
- type: DomainSecurity
  url: security/oracle-partitioning-domain-security.yml
- type: VulnerabilityDisclosure
  url: security/oracle-partitioning-vulnerability-disclosure.yml
- type: Security
  url: https://www.oracle.com/corporate/security-practices/assurance/vulnerability/
- type: Compliance
  url: https://www.oracle.com/corporate/cloud-compliance/
- type: DeveloperPortal
  url: https://developer.oracle.com/
- type: Documentation
  url: https://docs.oracle.com/en/database/oracle/oracle-database/19/vldbg/partition-concepts.html
- type: APIReference
  url: https://docs.oracle.com/en/database/oracle/oracle-rest-data-services/26.1/orrst/rest-endpoints.html
- type: GettingStarted
  url: https://docs.oracle.com/en/database/oracle/oracle-database/19/vldbg/partition-intro.html
- type: GitHubOrganization
  url: https://github.com/oracle
- type: White Papers
  url: https://www.oracle.com/technetwork/database/options/partitioning/
- type: Pricing
  url: https://www.oracle.com/a/ocom/docs/corporate/pricing/technology-price-list-070617.pdf
- type: SignUp
  url: https://signup.cloud.oracle.com/
- type: Support
  url: https://support.oracle.com
- type: TermsOfService
  url: https://www.oracle.com/legal/terms/
- type: PrivacyPolicy
  url: https://www.oracle.com/legal/privacy/
maintainers:
- FN: Kin Lane
  email: kin@apievangelist.com
tags:
- Agent Skills
- Composite-Partitioning
- Data Dictionary
- Database
- Enterprise Edition Option
- Hash-Partitioning
- Interval-Partitioning
- List-Partitioning
- MCP
- ORDS
- Oracle
- Oracle Database
- Partitioning
- Performance
- Range-Partitioning
- SQL
- Scalability
- Table Partitioning
- VLDB
x-enrichment:
  date: '2026-08-27'
  status: enriched
  artifacts_added: 22
  pass: local-v1
x-parent: oracle
x-relationship: product

Work with this as data

Every provider here is available over the APIs.io API and to AI agents over MCP.

MCP server

One button, every client — Claude, Cursor, VS Code and the rest.

https://apis.io/mcp

Tools for providers

9 MCP tools reach this
  • find_providersBrowse and filter every provider in the catalog.
  • get_provider_artifactsEvery artifact this provider publishes, grouped by type.
  • get_provider_operationsEvery operation across all of their OpenAPIs — one call instead of parsing every spec.
  • get_provider_toolsEvery MCP tool they ship, with the operation each wraps.
  • get_provider_evidenceHow each part of their score was established. Free — the basis for a claim should not sit behind it.
  • get_provider_ratingPRO — composite, band, trend and facet scores.
  • apis_io_searchSTART HERE — APIs, providers and tags for one query, each with its total.
  • resolveTurn a domain, URL or GitHub org into the provider it belongs to.
  • find_cohortsEvery scored population of providers in the catalog.
All 92 tools →

Call it yourself

curl for this page
This provider 
curl "https://apis.io/api/v1/providers/oracle-partitioning"
All providers 
curl "https://apis.io/api/v1/providers?limit=25"
Every operation they expose 
curl "https://apis.io/api/v1/providers/oracle-partitioning/operations?limit=25"
How their score was established 
curl "https://apis.io/api/v1/providers/oracle-partitioning/evidence"

Discovery needs no key. Ratings and market analysis are Pro.

Get an API key

Free tier, no form to fill in. Signing in shares your email address with us — we store it to create your key and to recognise you if you sign in with another provider. See our Privacy Policy and Terms.

GitHub Google LinkedIn

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