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 Data Dictionary API

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

Documentation Provider Profile APIs.io OpenAPI GitHub

Oracle Partitioning Data Dictionary 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 Data Dictionary. The published artifact set on APIs.io includes an OpenAPI specification, API documentation, and an API reference.

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

28 operations 28 paths 30 schemas 28 GET

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 Data Dictionary 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 28

Across 28 paths, the API surfaces 28 operations — 28 GET. Each is listed below with its method, path, parameters, and response codes.

Data Dictionary 28

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

GET
/database/db_links/
Get all database links
2 params → 200
GET
/database/db_links/{owner},{db_link}
Get a database link
2 params → 200
GET
/database/objects/
Get all database objects
2 params → 200
GET
/database/objects/{owner},{object_name},{object_type}
Get a specific object
3 params → 200
GET
/database/objects/arguments/
Get all arguments for functions and procedures
2 params → 200
GET
/database/objects/arguments/{object_id},{subprogram_id},{argument_name}
Get an argument
3 params → 200
GET
/database/objects/columns/
Get all table columns
2 params → 200
GET
/database/objects/columns/{owner},{table_name},{column_name}
Get a specific column
3 params → 200
GET
/database/objects/foreign_keys/
Get all foreign keys
2 params → 200
GET
/database/objects/foreign_keys/{owner},{constraint_name}
Get a specific foreign keys
2 params → 200
GET
/database/objects/functions/
Get all functions
2 params → 200
GET
/database/objects/functions/{object_id}
Get a specific function
1 param → 200
GET
/database/objects/indexes/
Get all indexes
2 params → 200
GET
/database/objects/indexes/{owner},{index_name}
Get a specific index
2 params → 200
GET
/database/objects/materialized_view_logs/
Get all materialized view logs
2 params → 200
GET
/database/objects/materialized_view_logs/{log_owner},{log_table}
Get information on a specific materialized view log
2 params → 200
GET
/database/objects/packages/procedures/
Get all procedures defined in package
2 params → 200
GET
/database/objects/packages/procedures/{object_id},{subprogram_id}
Get a procedure that is defined in package
2 params → 200
GET
/database/objects/partitions/
Get all partitions in the database
2 params → 200
GET
/database/objects/partitions/{table_owner},{table_name},{partition_name}
Get a partition
3 params → 200
GET
/database/objects/synonyms/
Get all synonyms in the database
2 params → 200
GET
/database/objects/synonyms/{owner},{synonym_name}
Get a synonym
2 params → 200
GET
/database/objects/tables/
Get all tables
2 params → 200
GET
/database/objects/tables/{owner},{table_name}
Get a specific table
2 params → 200
GET
/database/tablespaces/
Get all tablespaces
2 params → 200
GET
/database/tablespaces/{tablespace_name}
Get a specific tablespace
1 param → 200
GET
/database/objects/types/
Get all object types
2 params → 200
GET
/database/objects/types/{owner},{type_name}
Get an object type
2 params → 200

Schemas 30

The contract defines 30 schemas that model the data the API accepts and returns. The most detailed are DatabaseObjectsTablesItem (83 properties), DatabaseObjectsIndexesItem (61 properties), DatabaseObjectsPartitionsItem (53 properties), DatabaseObjectsColumnsItem (39 properties). Each schema is shown below with its type and property counts.

DatabaseArgumentsItem
object
This object represents arguments of the functions and procedures that are available in the database. The list of attributes may vary depending on database vers…
30 properties
DatabaseObjects
object
6 properties
DatabaseObjectsIndexesItem
object
Describes an index in the database.
61 properties
DatabaseObjectsForeignKeys
object
6 properties
DatabaseArguments
object
6 properties
DatabaseObjectsTables
object
6 properties
DatabaseObjectsIndexes
object
6 properties
DatabaseTablespacesItem
object
Describes a tablespace in the database.
18 properties
DatabaseObjectsColumns
object
6 properties
DatabaseObjectsPartitionsItem
object
This object represents partition-level partitioning information, partition storage parameters, and partition statistics generated by the DBMSSTATS package for…
53 properties
DatabaseObjectsColumnsItem
object
Describes the column of table, view, or cluster in the database.
39 properties
DatabaseObjectsTypes
object
6 properties
DatabaseTablespaces
object
6 properties
DatabaseObjectsTablesItem
object
This object describes a relational table in the database.
83 properties
DatabaseObjectsSynonyms
object
6 properties
DatabaseObjectsProceduresItem
object
Describes a procedure available in the database, along with associated properties. The list of attributes may vary depending on database version.
19 properties
LinkRelation
object
2 properties 2 required
DatabaseObjectsForeignKeysItem
object
Describes a foreign key constraint for referential integrity.
8 properties
DatabaseObjectsFunctionsItem
object
Describes a function available in the database, along with associated properties. The list of attributes may vary depending on database version.
19 properties
DatabaseLinks
object
6 properties
Filter
object
See Oracle REST Data Services production documentation 'Filtering in Queries' section.
DatabaseObjectsMaterializedViewLogs
object
6 properties
DatabaseObjectsFunctions
object
6 properties
DatabaseObjectsPartitions
object
6 properties
DatabaseObjectsItem
object
A description of an object in the database.
27 properties
DatabaseObjectsProcedures
object
6 properties
DatabaseObjectsMaterializedViewLogsItem
object
This object describes a materialized view log in the database.
19 properties
DatabaseObjectsTypesItem
object
This object describes an object type in the database.
17 properties
DatabaseObjectsSynonymsItem
object
This object describes a synonym in the database. The list of attributes may vary depending on database version.
7 properties
DatabaseLinksItem
object
A database link is a connection between two physical database servers that allows a client to access them as one logical database.
8 properties

Specification

The full machine-readable OpenAPI contract behind this narrative.

Source

oracle-partitioning-data-dictionary-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 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
Oracle Partitioning ORDS REST Services API
AE Profile APIs.io
#Data Dictionary
← Back to O APIs
API Details
ID
oracle-partitioning:oracle-partitioning-data-dictionary-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-data-dictionary-api&limit=10"
Everything under a tag 
curl "https://api.apievangelist.com/v1/tags/oracle-partitioning-data-dictionary-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 Data Dictionary 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.