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 ORDS REST Services API

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

Documentation Provider Profile APIs.io OpenAPI GitHub

Oracle Partitioning ORDS REST Services API is one of 25 APIs that Oracle Partitioning publishes on the APIs.io network, described by a machine-readable OpenAPI specification.

Tagged areas include ORDS REST Services. The published artifact set on APIs.io includes an OpenAPI specification, API documentation, and an API reference.

This API exposes 61 operations across 34 paths, and defines 7 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.

61 operations 34 paths 7 schemas 9 DELETE32 GET10 POST10 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 ORDS REST Services 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 61

Across 34 paths, the API surfaces 61 operations — 9 DELETE, 32 GET, 10 POST, 10 PUT. Each is listed below with its method, path, parameters, and response codes.

ORDS REST Services 61

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

GET
/ords/properties/
Get all ORDS properties values
ordsPropertiesGet 2 params → 200
GET
/ords/properties/{key}
Get an ORDS property value
ordsPropertiesKeyGet 1 param → 200
PUT
/ords/properties/{key}
Set an ORDS property value
ordsPropertiesKeyPut 1 param body → 200
DELETE
/ords/properties/{key}
Unset an ORDS property value
ordsPropertiesKeyDelete 1 param → 204
GET
/ords/properties/{schema}/{key}
Get an ORDS property value for a schema
ordsPropertiesSchemaKeyGet 2 params → 200
PUT
/ords/properties/{schema}/{key}
Set an ORDS property value for a schema
ordsPropertiesSchemaKeyPut 2 params body → 200
DELETE
/ords/properties/{schema}/{key}
Unset an ORDS property value for a schema
ordsPropertiesSchemaKeyDelete 2 params → 204
GET
/ords/rest/modules/
Get all REST modules
2 params → 200
POST
/ords/rest/modules/
Create a REST module
body → 200201409404
GET
/ords/rest/modules/{id}
Get a REST module
1 param → 200
PUT
/ords/rest/modules/{id}
Update a REST module
1 param body → 200400404409
GET
/ords/rest/modules/{id}/source
Get a REST module source
1 param → 200404
GET
/ords/rest/templates/
Get all REST module templates
2 params → 200
POST
/ords/rest/templates/
Create a REST module template
body → 201400404409
GET
/ords/rest/templates/{id}
Get a REST module template
1 param → 200
PUT
/ords/rest/templates/{id}
Update a REST module template
1 param body → 200400404409
DELETE
/ords/rest/templates/{id}
Delete a REST module template
1 param → 204
GET
/ords/rest/handlers/
Get all REST template handlers
2 params → 200
POST
/ords/rest/handlers/
Create a REST template handler
body → 201400404409
GET
/ords/rest/handlers/{id}
Get a REST template handler
1 param → 200
PUT
/ords/rest/handlers/{id}
Update a REST template handler
1 param body → 200400404409
DELETE
/ords/rest/handlers/{id}
Delete a REST template handler
1 param → 204404
GET
/ords/rest/handlers/{id}/source
Get a REST handler source
1 param → 200
GET
/ords/rest/parameters/
Get all REST handler parameters
2 params → 200
POST
/ords/rest/parameters/
Create a REST handler parameter
body → 201400404409
GET
/ords/rest/parameters/{id}
Get a REST handler parameter
1 param → 200
PUT
/ords/rest/parameters/{id}
Update a REST handler parameter
1 param body → 200400404409
DELETE
/ords/rest/parameters/{id}
Delete a REST handler parameter
1 param → 204
GET
/ords/rest/roles/
Get all ORDS roles
2 params → 200
POST
/ords/rest/roles/
Create an ORDS role
body → 200400409
GET
/ords/rest/roles/{id}
Get an ORDS role
1 param → 200
PUT
/ords/rest/roles/{id}
Update an ORDS role
1 param body → 201400403404
DELETE
/ords/rest/roles/{id}
Delete an ORDS role
1 param → 204
GET
/ords/rest/roles/{id}/privileges/
Get all ORDS privileges for a specific role
1 param → 200
GET
/ords/rest/privileges/
Get all ORDS privileges
2 params → 200
POST
/ords/rest/privileges/
Create an ORDS privilege
body → 201400404409
GET
/ords/rest/privileges/{id}
Get an ORDS privilege
1 param → 200
PUT
/ords/rest/privileges/{id}
Update an ORDS privilege
1 param body → 200400403404
DELETE
/ords/rest/privileges/{id}
Delete an ORDS privilege
1 param → 204
GET
/ords/rest/privileges/{id}/modules/
Get all REST modules in a privilege
1 param → 200
GET
/ords/rest/privileges/{id}/patterns/
Get all REST patterns in a privilege
1 param → 200
GET
/ords/rest/privileges/{id}/roles/
Get all ORDS roles in a privilege
1 param → 200
GET
/ords/rest/privilege/modules/
Get all protected REST modules
2 params → 200
GET
/ords/rest/clients/
Get all ORDS OAuth clients
2 params → 200
POST
/ords/rest/clients/
Create an ORDS OAuth client
body → 201400409
GET
/ords/rest/clients/{id}
Get an ORDS OAuth client
1 param → 200
PUT
/ords/rest/clients/{id}
Update an ORDS OAuth client
1 param body → 200400404409
DELETE
/ords/rest/clients/{id}
Delete an ORDS OAuth client
1 param → 204404409
POST
/ords/rest/clients/{id}/logo/
Updates the ORDS OAuth client avatar image.
1 param body → 201
POST
/ords/rest/clients/{id}/secret/{slotid}
Register or Rotate the ORDS OAuth client secret.
4 params → 201
DELETE
/ords/rest/clients/{id}/secret/{slotid}
Revoke the ORDS OAuth client secret.
3 params → 204
GET
/ords/rest/clients/{id}/privileges/
Get all ORDS privileges in an OAuth client
1 param → 200
GET
/ords/rest/clients/{id}/roles/
Get all ORDS roles in an OAuth client
1 param → 200
GET
/ords/rest/autorest/
Get all REST enabled objects
2 params → 200
POST
/ords/rest/autorest/
REST enable an object
body → 201404409403
GET
/ords/rest/autorest/{id}
Get a REST enabled object
1 param → 200
PUT
/ords/rest/autorest/{id}
Update or disables a REST enabled object
1 param body → 200404403409
GET
/ords/rest/autorest/summary
Get count of all the REST enabled objects
→ 200
GET
/ords/rest/autorest/{id}/metadata
Get a REST enabled object metadata
1 param → 200400404
GET
/ords/rest/overview/
Get current ORDS schema and count of all current schema REST objects and count of all REST modules
→ 200
GET
/ords/rest/overview/objects_recent
Get all current schema recent REST objects
2 params → 200

Schemas 7

The contract defines 7 schemas that model the data the API accepts and returns. The most detailed are RestClientCollectionItem (29 properties), ItemsCollection (6 properties), RestClientCollection (6 properties), RestClientSecretItem (5 properties). Each schema is shown below with its type and property counts.

RestClientSecretItem
object
This object represents a new client secret .
5 properties
LinkRelation
object
2 properties 2 required
RestClientCollectionItem
object
ORDS OAuth clients
29 properties
Filter
object
See Oracle REST Data Services production documentation 'Filtering in Queries' section.
RestClientCollection
object
6 properties
ResourceItem
object
1 property
ItemsCollection
object
6 properties

Specification

The full machine-readable OpenAPI contract behind this narrative.

Source

oracle-partitioning-ords-rest-services-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 General 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
#ORDS REST Services
← Back to O APIs
API Details
ID
oracle-partitioning:oracle-partitioning-ords-rest-services-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-ords-rest-services-api&limit=10"
Everything under a tag 
curl "https://api.apievangelist.com/v1/tags/oracle-partitioning-ords-rest-services-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 ORDS REST Services 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.