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 Database

Oracle Database Data Dictionary API

Database tables, views, columns, indexes, and object metadata

Provider Profile APIs.io OpenAPI GitHub

Oracle Database Data Dictionary API is one of 29 APIs that Oracle Database publishes on the APIs.io network, described by a machine-readable OpenAPI specification.

This API exposes 5 JSON Schema definitions.

Tagged areas include Data Dictionary. The published artifact set on APIs.io includes an OpenAPI specification, API documentation, a JSON-LD context, an API reference, and 5 JSON Schemas.

This API exposes 12 operations across 12 paths, and defines 16 schemas. It is described by OpenAPI 3.2.0, at version 25.4.0.

Requests are made against a single base URL, https://{host}:{port}/ords.

12 operations 12 paths 16 schemas 12 GET

Metadata

The identity and technical contract details declared by the specification.

Specification
OpenAPI 3.2.0
API Version
25.4.0
Server
https://{host}:{port}/ords
Authentication
OAuth 2.0, HTTP Basic
Contact
Oracle Support
License
Oracle Technology Network License
Terms of Service
View terms
Resource Areas
1

Authentication & Security 2

Oracle Database Data Dictionary API declares 2 security schemes for authenticating requests. It supports OAuth 2.0 (oauth2) using the clientCredentials and authorizationCode flows. It accepts HTTP basic authentication (basicAuth). By default, every request must be authenticated.

Paths & Operations 12

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

Data Dictionary 12

Database tables, views, columns, indexes, and object metadata

GET
/database/objects/tables/
Oracle Database Get all tables
getTables 2 params → 200401
GET
/database/objects/tables/{owner},{table_name}
Oracle Database Get a specific table
getTable 2 params → 200401404
GET
/database/objects/columns/
Oracle Database Get all table columns
getColumns 2 params → 200401
GET
/database/objects/columns/{owner},{table_name},{column_name}
Oracle Database Get a specific column
getColumn 3 params → 200401404
GET
/database/objects/indexes/
Oracle Database Get all indexes
getIndexes 2 params → 200401
GET
/database/objects/indexes/{owner},{index_name}
Oracle Database Get a specific index
getIndex 2 params → 200401404
GET
/database/objects/functions/
Oracle Database Get all functions
getFunctions → 200401
GET
/database/objects/functions/{object_id}
Oracle Database Get a specific function
getFunction 1 param → 200401404
GET
/database/objects/foreign_keys/
Oracle Database Get all foreign keys
getForeignKeys → 200401
GET
/database/db_links/
Oracle Database Get all database links
getDatabaseLinks → 200401
GET
/database/db_links/{owner},{db_link}
Oracle Database Get a specific database link
getDatabaseLink 2 params → 200401404
GET
/database/tablespaces/
Oracle Database Get all tablespaces
getTablespacesDict → 200401

Schemas 16

The contract defines 16 schemas that model the data the API accepts and returns. The most detailed are ColumnMetadata (7 properties), Tablespace (7 properties), TableMetadata (7 properties), IndexMetadata (6 properties). Each schema is shown below with its type and property counts.

Error
object
3 properties
Tablespace
object
7 properties
TableMetadata
object
7 properties
DatabaseLinkList
object
1 property
ForeignKeyList
object
1 property
TablespaceList
object
1 property
Link
object
2 properties
DatabaseLink
object
5 properties
PaginatedResponse
object
6 properties
FunctionMetadata
object
5 properties
IndexMetadata
object
6 properties
ColumnList
TableList
IndexList
object
1 property
FunctionList
object
1 property
ColumnMetadata
object
7 properties

Specification

The full machine-readable OpenAPI contract behind this narrative.

Source

oracle-database-data-dictionary-api-openapi.yml Raw ↑

Other APIs Oracle Database publishes across the network.

Oracle Database API for MongoDB
AE Profile APIs.io
Oracle Database JDBC
AE Profile APIs.io
Oracle Call Interface (OCI)
AE Profile APIs.io
Oracle SQL Developer REST API
AE Profile APIs.io
Oracle Transactional Event Queues (TxEventQ)
AE Profile APIs.io
Oracle Database APEX API
AE Profile APIs.io
Oracle Database Autonomous Databases API
AE Profile APIs.io
Oracle Database Backups API
AE Profile APIs.io
Oracle Database Bulk Operations API
AE Profile APIs.io
Oracle Database Collections API
AE Profile APIs.io
Oracle Database Data Guard API
AE Profile APIs.io
Oracle Database Data Pump API
AE Profile APIs.io
#Data Dictionary
← Back to O APIs
API Details
ID
oracle-database:oracle-database-data-dictionary-api
Server
https://{host}:{port}/ords
Provider
Oracle Database
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-database-data-dictionary-api&limit=10"
Everything under a tag 
curl "https://api.apievangelist.com/v1/tags/oracle-database-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 Database 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.