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
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.

agent ready

Solid contracts, transparent operations, and an easy start — typically complete on four or five facets with one clear soft spot.

Kin Score

API Evangelist profiles Oracle Partitioning the way a machine reads it — 33 machine-readable artifacts across 1 API, pulled from the provider's own public surface and indexed so a developer, an analyst, or an AI agent can evaluate it against every other provider on the network.

Every provider in the network is reduced to the same set of machine-readable artifacts — OpenAPI contracts, event specifications, GraphQL schemas, runnable collections, pricing and rate-limit signals, security posture, OAuth scopes, and the agent surfaces (MCP servers and skills) that let software drive the API on its own. We profile them because the interface is the part of a company you can actually inspect: it is a truer signal of what a provider does than any marketing page. From those artifacts we compute the Kin Score — Oracle Partitioning scores 58.6/100 (strong), with a separate agent-readiness read of 40/100 (agent ready). The full breakdown is below, followed by every artifact we hold — each card links through to its machine-readable definition on apis.io.

Kin Score

This is the API Evangelist rating — a single, repeatable read computed from the artifacts on this page. Green fill is points earned; the red track is points possible, so every bar shows earned-versus-possible at a glance. Every facet and dimension name is a link: it opens that measurement's page on APIs.io, where the rating runs across the whole catalog — the exact checks that feed it, how every profiled provider distributes on it, and who is at the top of it.

Kin Score Kin Score How this is scored →
scored 2026-09-08 · rubric v0.20.0
Composite quality — 58.6/100 · strong
Contract Quality 11.4 / 25
Access Clarity 13.7 / 20
Discoverability 6.9 / 10
Oracle Partitioning Kin Score — API readiness rating by API Evangelist

Put this on your own site. The badge is drawn live from Oracle Partitioning's current Kin Score — paste it once and it updates itself every time the score is recomputed. It follows your visitor's light or dark setting, and it links back here so anyone who sees it can read the full breakdown.

<!-- Kin Score · API Evangelist -->
<a href="https://providers.apievangelist.com/providers/oracle-partitioning/"
   title="Oracle Partitioning on API Evangelist — API profile and Kin Score">
  <img src="https://apis.io/badge/oracle-partitioning.svg"
       alt="Oracle Partitioning Kin Score — API readiness rating by API Evangelist" width="150" height="150" loading="lazy">
</a>

More shapes, themes and sizes → · Score as JSON · How badges work

How we profile Oracle Partitioning

Each block below is one kind of artifact we hold for Oracle Partitioning. For each we say what it is and why it earns a place in the profile, then list every one we've indexed — capped at two rows, scroll within the panel for the rest.

APIs 25

Each API is captured as its own OpenAPI definition — every operation, parameter, and response. This is the single most useful machine-readable description of what an API does, and it's what lets us score, lint, mock, and generate against it without asking the provider for anything.

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 within the panel for all 25 ·

MCP Servers 1

Model Context Protocol servers expose these APIs directly to AI agents. We profile them because agent-native access is the fastest-growing way this provider's capabilities actually get used.

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

Pricing is part of the interface. Machine-readable plans tell you what a tier costs and includes before you commit — one of the things the Kin Score reads for access clarity — renamed from commercial clarity in rubric 0.12, because a free statutory interface has access terms and no commercial ones.

Published pricing tiers and plan structures.

Rate Limits 1

Rate limits are the difference between a demo that works and a production integration that doesn't fall over. Publishing them is an operational-transparency signal — and a hard requirement for any agent that plans its own throughput.

Documented rate limits and quota policies.

Oracle Partitioning Rate Limits

0 limits

RATE LIMITS

FinOps 1

Cost, billing, and metering signals let a buyer model the financial operations of an API before it's live. We profile them for the same reason we profile pricing: the money is part of the contract.

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

Security Posture 3

Authentication, domain security, vulnerability disclosure, and trust-center signals — the evidence that a provider takes security seriously enough to document it. We profile it because you can't govern what you can't see.

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

Scopes 1

OAuth scopes are the vocabulary of least-privilege access. Profiling them shows exactly what an integration — or an agent acting on a user's behalf — is allowed to do.

OAuth scopes governing access to this provider's APIs.

Oracle Partitioning Scopes

OAuth 2.0 · no documented scopes

0 scopes

SCOPES

Resources

Every other property we hold for Oracle Partitioning — documentation, portals, status pages, policies, and corporate surface — grouped by the job it does, following the integrator's arc from getting started to running in production.

Documentation 3

Reference material describing how the API behaves

Agent Surfaces 3

MCP servers, agent skills, and machine-readable catalogs

Company 1

The organization behind the API

Other 2

Properties that don't map to a standard resource type

← All providers · Data indexed from github.com/api-evangelist/oracle-partitioning · machine-readable index on apis.io

Where this information came from

This is an independent, third-party profile of Oracle Partitioning, 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.