Oracle Partitioning Data Tools API
Services related to loading, manipulating and analyzing data.
Work with this as data
Every API 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 apis
7 MCP tools reach this
find_apisBrowse and filter every API in the catalog.get_api_artifactsOne API's artifacts, grouped by type.get_openapiThe primary OpenAPI for this API.find_similar_apisAPIs that look like this one.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.
Call it yourself
curl for this page
This API
curl "https://apis.io/api/v1/apis/oracle-partitioning-data-tools-api"
All apis
curl "https://apis.io/api/v1/apis?limit=25"Discovery needs no key. Ratings and market analysis are Pro.
OpenAPI Specification
openapi: 3.2.0
info:
description: '<p>Provides the Oracle REST Data Services (ORDS) users the ability to perform Oracle Database management and monitoring operations through a user-friendly REST API. Depending on the database version and configuration, ORDS database APIs provide services such as manage pluggable databases, export data, and review database performance.</p><p>To install and configure Oracle REST Data Services refer to the <a href=https://docs.oracle.com/pls/topic/lookup?ctx=ords-latest&id=ORDIG> Oracle® REST Data Services Installation and Configuration Guide</a>.</p>
<p>An OpenAPI V3 document that describes the available ORDS database API services can be retrieved from a running ORDS instance. The API document can be imported into compatible development tools and invoked from there. The URL to retrieve the API document depends on the your configuration. <p><p>The pattern for the API document URL is: </p>
<code>https://<server>/<context root>/<my database>/<my schema>/_/db-api/stable/<service path> </code>
<p>Where, the <code><my database></code> and <code><my schema></code> variables can be optional, depending on the ORDS configuration and the service invoked.'
version: 2026.03.26
title: Oracle REST Data Services Data Tools API
contact:
name: Oracle REST Data Services
url: https://www.oracle.com/database/technologies/appdev/rest.html
x-summary: Provides the Oracle REST Data Services (ORDS) users the ability to perform Oracle Database management and monitoring operations through a user-friendly REST API.
tags:
- name: Data Tools
description: Services related to loading, manipulating and analyzing data.
paths:
/data-tools/data-loads/:
post:
description: Creates data load jobs
operationId: createDataLoadJobs
tags:
- Data Tools
parameters: []
requestBody:
$ref: '#/components/requestBodies/data-loads'
responses:
'201':
$ref: '#/components/responses/data-load-job-ids'
description: Data Load Jobs Created
'204':
description: No content
summary: Creates data load jobs
x-internal-id: data-tools-data-loads--post
x-filename-id: data-tools-data-loads-post
get:
description: Gets data load jobs
operationId: getDataLoadJobs
tags:
- Data Tools
parameters: []
responses:
'200':
$ref: '#/components/responses/data-load-statuses'
'204':
description: No jobs found
summary: Gets data load jobs
x-internal-id: data-tools-data-loads--get
x-filename-id: data-tools-data-loads-get
/data-tools/data-loads/{owner},{data_load_job_id}:
get:
description: Gets specific data load job
operationId: getDataLoadJob
tags:
- Data Tools
parameters:
- name: owner
in: path
description: Owner for the data load.
required: true
schema:
type: string
- name: data_load_job_id
in: path
description: name of data load job to get
required: true
schema:
type: string
style: simple
responses:
'200':
$ref: '#/components/responses/data-load-statuses'
'404':
description: Data Load Job not found
summary: Gets specific data load job
x-internal-id: data-tools-data-loads-{owner},{data_load_job_id}-get
x-filename-id: data-tools-data-loads-owner-data_load_job_id-get
delete:
description: Delete data load job
operationId: deleteDataLoadJob
tags:
- Data Tools
parameters:
- name: owner
in: path
description: Owner for the data load.
required: true
schema:
type: string
- name: data_load_job_id
in: path
required: true
style: simple
description: Data load job ID to delete
schema:
type: integer
responses:
'204':
description: Data load job deleted
'404':
description: Data load job not found
summary: Delete data load job
x-internal-id: data-tools-data-loads-{owner},{data_load_job_id}-delete
x-filename-id: data-tools-data-loads-owner-data_load_job_id-delete
/data-tools/data-loads/{owner},{data_load_job_id}/progress:
get:
description: Gets progress of data load job
operationId: getDataLoadJobProgress
tags:
- Data Tools
parameters:
- name: owner
in: path
description: Owner for the data load.
required: true
schema:
type: string
- name: data_load_job_id
in: path
description: name of data load job to get
required: true
schema:
type: string
style: simple
responses:
'200':
$ref: '#/components/responses/data-load-statuses'
'404':
description: Data Load Job not found
summary: Gets progress of data load job
x-internal-id: data-tools-data-loads-{owner},{data_load_job_id}-progress-get
x-filename-id: data-tools-data-loads-owner-data_load_job_id-progress-get
/data-tools/jobs/:
post:
description: Creates a Data Tools job
operationId: createDataToolsJobs
tags:
- Data Tools
parameters: []
requestBody:
$ref: '#/components/requestBodies/data-tools-job'
responses:
'201':
$ref: '#/components/responses/data-tools-job'
description: Data Tools Job Created
'204':
description: No content
summary: Creates a Data Tools job
x-internal-id: data-tools-jobs--post
x-filename-id: data-tools-jobs-post
get:
description: Gets data tools jobs
operationId: getDataToolsJobs
tags:
- Data Tools
parameters: []
responses:
'200':
$ref: '#/components/responses/data-tools-jobs'
'204':
description: No jobs found
summary: Gets data tools jobs
x-internal-id: data-tools-jobs--get
x-filename-id: data-tools-jobs-get
/data-tools/jobs/run:
post:
description: Runs a Data Tools job
operationId: runDataToolsJobs
tags:
- Data Tools
parameters: []
responses:
'201':
$ref: '#/components/responses/data-tools-job'
description: Data Tools Job started
'204':
description: No content
summary: Runs a Data Tools job
x-internal-id: data-tools-jobs-run-post
x-filename-id: data-tools-jobs-run-post
/data-tools/jobs/activity:
get:
description: Gets Data Tools jobs activity
operationId: getDataToolsJobActivity
tags:
- Data Tools
parameters: []
responses:
'201':
$ref: '#/components/responses/data-tools-jobs'
description: Data Tools Jobs Activity
'204':
description: No content
summary: Gets Data Tools jobs activity
x-internal-id: data-tools-jobs-activity-get
x-filename-id: data-tools-jobs-activity-get
/data-tools/jobs/activity/{owner},{job_name}:
get:
description: Checks specific Data Tools job activity
operationId: getDataToolsJobActivityByName
tags:
- Data Tools
parameters:
- name: owner
in: path
description: Owner of the job
required: true
schema:
type: string
- name: job_name
in: path
description: Name of job to get
required: true
schema:
type: string
style: simple
responses:
'201':
$ref: '#/components/responses/data-tools-jobs'
description: Data Tools Jobs Activity
'204':
description: No content
summary: Checks specific Data Tools job activity
x-internal-id: data-tools-jobs-activity-{owner},{job_name}-get
x-filename-id: data-tools-jobs-activity-owner-job_name-get
/data-tools/jobs/activity/{owner},{job_name}/{id}:
get:
description: Checks specific Data Tools job run activity
operationId: getDataToolsJobActivityById
tags:
- Data Tools
parameters:
- name: owner
in: path
description: Owner of the job
required: true
schema:
type: string
- name: job_name
in: path
description: Name of job to get
required: true
schema:
type: string
style: simple
- name: id
in: path
description: ID of job run to get
required: true
schema:
type: number
style: simple
responses:
'201':
$ref: '#/components/responses/data-tools-jobs'
description: Data Tools Jobs Activity
'204':
description: No content
summary: Checks specific Data Tools job run activity
x-internal-id: data-tools-jobs-activity-{owner},{job_name}-{id}-get
x-filename-id: data-tools-jobs-activity-owner-job_name-id-get
/data-tools/jobs/activity-detail:
get:
description: Gets Data Tools jobs activity detail
operationId: getDataToolsJobActivityDetail
tags:
- Data Tools
parameters: []
responses:
'201':
$ref: '#/components/responses/data-tools-jobs'
description: Data Tools Jobs Activity Details
'204':
description: No content
summary: Gets Data Tools jobs activity detail
x-internal-id: data-tools-jobs-activity-detail-get
x-filename-id: data-tools-jobs-activity-detail-get
/data-tools/jobs/activity-detail/{owner},{job_name}:
get:
description: Checks specific Data Tools job activity detail
operationId: getDataToolsJobActivityDetailByName
tags:
- Data Tools
parameters:
- name: owner
in: path
description: Owner of the job
required: true
schema:
type: string
- name: job_name
in: path
description: Name of job to get
required: true
schema:
type: string
style: simple
responses:
'201':
$ref: '#/components/responses/data-tools-jobs'
description: Data Tools Jobs Activity Details
'204':
description: No content
summary: Checks specific Data Tools job activity detail
x-internal-id: data-tools-jobs-activity-detail-{owner},{job_name}-get
x-filename-id: data-tools-jobs-activity-detail-owner-job_name-get
/data-tools/jobs/activity-detail/{owner},{job_name}/{id}:
get:
description: Checks specific Data Tools job run activity detail
operationId: getDataToolsJobActivityDetailById
tags:
- Data Tools
parameters:
- name: owner
in: path
description: Owner of the job
required: true
schema:
type: string
- name: job_name
in: path
description: Name of job to get
required: true
schema:
type: string
style: simple
- name: id
in: path
description: ID of job run to get
required: true
schema:
type: number
style: simple
responses:
'201':
$ref: '#/components/responses/data-tools-jobs'
description: Data Tools Jobs Activity Details
'204':
description: No content
summary: Checks specific Data Tools job run activity detail
x-internal-id: data-tools-jobs-activity-detail-{owner},{job_name}-{id}-get
x-filename-id: data-tools-jobs-activity-detail-owner-job_name-id-get
/data-tools/jobs/running:
get:
description: Gets running Data Tools jobs
operationId: getDataToolsJobsRunning
tags:
- Data Tools
parameters: []
responses:
'201':
$ref: '#/components/responses/data-tools-jobs'
description: Running Data Tools Jobs
'204':
description: No content
summary: Gets running Data Tools jobs
x-internal-id: data-tools-jobs-running-get
x-filename-id: data-tools-jobs-running-get
/data-tools/jobs/running/{owner},{job_name}:
get:
description: Gets specific running Data Tools job
operationId: getDataToolsJobsRunningByName
tags:
- Data Tools
parameters:
- name: owner
in: path
description: Owner of the job
required: true
schema:
type: string
- name: job_name
in: path
description: Name of job to get
required: true
schema:
type: string
style: simple
responses:
'201':
$ref: '#/components/responses/data-tools-jobs'
description: Running Data Tools Jobs
'204':
description: No content
summary: Gets specific running Data Tools job
x-internal-id: data-tools-jobs-running-{owner},{job_name}-get
x-filename-id: data-tools-jobs-running-owner-job_name-get
/data-tools/jobs/running/{owner},{job_name}/{id}:
get:
description: Gets specific running Data Tools job run
operationId: getDataToolsJobsRunningById
tags:
- Data Tools
parameters:
- name: owner
in: path
description: Owner of the job
required: true
schema:
type: string
- name: job_name
in: path
description: Name of job to get
required: true
schema:
type: string
style: simple
- name: id
in: path
description: ID of job run to get
required: true
schema:
type: number
style: simple
responses:
'201':
$ref: '#/components/responses/data-tools-jobs'
description: Running Data Tools Jobs
'204':
description: No content
summary: Gets specific running Data Tools job run
x-internal-id: data-tools-jobs-running-{owner},{job_name}-{id}-get
x-filename-id: data-tools-jobs-running-owner-job_name-id-get
/data-tools/jobs/{owner},{job_name}:
get:
description: Gets specific data tools job
operationId: getDataToolsJob
tags:
- Data Tools
parameters:
- name: owner
in: path
description: Owner of the job
required: true
schema:
type: string
- name: job_name
in: path
description: Name of job to get
required: true
schema:
type: string
style: simple
responses:
'200':
$ref: '#/components/responses/data-tools-job'
'404':
description: Data Tools Job not found
summary: Gets specific data tools job
x-internal-id: data-tools-jobs-{owner},{job_name}-get
x-filename-id: data-tools-jobs-owner-job_name-get
delete:
description: Delete Data Tools job
operationId: deleteDataToolsJob
tags:
- Data Tools
parameters:
- name: owner
in: path
description: Owner of the job
required: true
schema:
type: string
- name: job_name
in: path
required: true
style: simple
description: Name of job to delete
schema:
type: string
responses:
'204':
description: Job deleted
'404':
description: Job not found
summary: Delete Data Tools job
x-internal-id: data-tools-jobs-{owner},{job_name}-delete
x-filename-id: data-tools-jobs-owner-job_name-delete
patch:
description: Updates data tools job
operationId: updateDataToolsJob
tags:
- Data Tools
parameters:
- name: owner
in: path
description: Owner of the job
required: true
schema:
type: string
- name: job_name
in: path
description: Name of job to update
required: true
schema:
type: string
style: simple
responses:
'200':
$ref: '#/components/responses/data-tools-job'
'404':
description: Data Tools Job not found
summary: Updates data tools job
x-internal-id: data-tools-jobs-{owner},{job_name}-patch
x-filename-id: data-tools-jobs-owner-job_name-patch
/data-tools/surveys/:
post:
description: Surveys input data
operationId: createSurvey
tags:
- Data Tools
parameters: []
requestBody:
$ref: '#/components/requestBodies/surveys'
responses:
'201':
$ref: '#/components/responses/surveys'
'204':
description: No content
summary: Surveys input data
x-internal-id: data-tools-surveys--post
x-filename-id: data-tools-surveys-post
/data-tools/live-table-feeds/:
post:
description: Creates Live Table Feed
operationId: createLiveTableFeed
tags:
- Data Tools
parameters: []
requestBody:
$ref: '#/components/requestBodies/live-table-feeds'
responses:
'201':
description: Live Table Feeds were succesfully created
content:
application/json:
schema:
$ref: '#/components/schemas/live-table-feeds'
'204':
description: No content
'409':
description: Name conflict with existing Live Table Feed
summary: Creates Live Table Feed
x-internal-id: data-tools-live-table-feeds--post
x-filename-id: data-tools-live-table-feeds-post
get:
description: Gets Live Table Feeds
operationId: getLiveTableFeeds
tags:
- Data Tools
parameters: []
responses:
'200':
$ref: '#/components/responses/live-table-feeds'
'404':
description: No Live Table Feeds found
summary: Gets Live Table Feeds
x-internal-id: data-tools-live-table-feeds--get
x-filename-id: data-tools-live-table-feeds-get
/data-tools/live-table-feeds/{owner},{feed_name}:
get:
description: Gets specific Live Table Feed
operationId: getLiveTableFeed
tags:
- Data Tools
parameters:
- name: owner
in: path
description: Owner for the Live Table Feed.
required: true
schema:
type: string
- name: feed_name
in: path
required: true
style: simple
schema:
$ref: '#/components/schemas/live_table_feed_name'
responses:
'200':
$ref: '#/components/responses/live-table-feeds'
'404':
description: Live Table Feed not found
summary: Gets specific Live Table Feed
x-internal-id: data-tools-live-table-feeds-{owner},{feed_name}-get
x-filename-id: data-tools-live-table-feeds-owner-feed_name-get
put:
description: Modify Live Table Feed
operationId: putLiveTableFeed
tags:
- Data Tools
parameters:
- name: owner
in: path
description: Owner for the Live Table Feed.
required: true
schema:
type: string
- name: feed_name
in: path
required: true
style: simple
schema:
$ref: '#/components/schemas/live_table_feed_name'
responses:
'200':
$ref: '#/components/responses/live-table-feeds'
'404':
description: Live Table Feed not found
summary: Modify Live Table Feed
x-internal-id: data-tools-live-table-feeds-{owner},{feed_name}-put
x-filename-id: data-tools-live-table-feeds-owner-feed_name-put
delete:
description: Delete Live Table Feed
operationId: deleteLiveTableFeed
tags:
- Data Tools
parameters:
- name: owner
in: path
description: Owner for the Live Table Feed.
required: true
schema:
type: string
- name: feed_name
in: path
required: true
style: simple
description: Live Table Feed to delete
schema:
$ref: '#/components/schemas/live_table_feed_name'
responses:
'204':
description: Live Table Feed deleted
'404':
description: Live Table Feed not found
summary: Delete Live Table Feed
x-internal-id: data-tools-live-table-feeds-{owner},{feed_name}-delete
x-filename-id: data-tools-live-table-feeds-owner-feed_name-delete
/data-tools/live-table-feeds/{owner},{feed_name}/key:
get:
description: Gets Live Table Feed notification key
operationId: getLiveTableFeedKey
tags:
- Data Tools
parameters:
- name: owner
in: path
description: Owner for the Live Table Feed.
required: true
schema:
type: string
- name: feed_name
in: path
required: true
style: simple
schema:
$ref: '#/components/schemas/live_table_feed_name'
responses:
'200':
$ref: '#/components/responses/live-table-feed-key'
'404':
description: Live Table Feed not found
summary: Gets Live Table Feed notification key
x-internal-id: data-tools-live-table-feeds-{owner},{feed_name}-key-get
x-filename-id: data-tools-live-table-feeds-owner-feed_name-key-get
/data-tools/live-table-feeds/{owner},{feed_name}/load_new_data:
post:
description: Triggers data load for Live Table Feed.
operationId: triggerLiveTableFeed
tags:
- Data Tools
parameters:
- name: owner
in: path
description: Owner for the Live Table Feed.
required: true
schema:
type: string
- name: feed_name
in: path
required: true
style: simple
schema:
$ref: '#/components/schemas/live_table_feed_name'
responses:
'200':
$ref: '#/components/responses/live-table-feeds'
'404':
description: Live Table Feed not found
summary: Triggers data load for Live Table Feed
x-internal-id: data-tools-live-table-feeds-{owner},{feed_name}-load_new_data-post
x-filename-id: data-tools-live-table-feeds-owner-feed_name-load_new_data-post
/data-tools/cloud-storage-links/:
post:
description: Creates Cloud Storage Link
operationId: createCloudStorageLink
tags:
- Data Tools
parameters: []
requestBody:
$ref: '#/components/requestBodies/cloud-storage-links'
responses:
'201':
description: Cloud Storage Links were succesfully created
content:
application/json:
schema:
$ref: '#/components/schemas/cloud-storage-links'
'204':
description: No content
'409':
description: Name conflict with existing Cloud Storage Link
summary: Creates Cloud Storage Link
x-internal-id: data-tools-cloud-storage-links--post
x-filename-id: data-tools-cloud-storage-links-post
get:
description: Gets Cloud Storage Links
operationId: getCloudStorageLinks
tags:
- Data Tools
parameters: []
responses:
'200':
$ref: '#/components/responses/cloud-storage-links'
'404':
description: No Cloud Storage Links found
summary: Gets Cloud Storage Links
x-internal-id: data-tools-cloud-storage-links--get
x-filename-id: data-tools-cloud-storage-links-get
/data-tools/cloud-storage-links/{owner},{storage_link_name}:
get:
description: Gets specific Cloud Storage Link
operationId: getCloudStorageLink
tags:
- Data Tools
parameters:
- name: owner
in: path
description: Owner for the Cloud Storage Link.
required: true
schema:
type: string
- name: storage_link_name
in: path
description: Name of Cloud Storage Link to get
required: true
schema:
type: string
style: simple
responses:
'200':
$ref: '#/components/responses/cloud-storage-links'
'404':
description: Cloud Storage Link not found
summary: Gets specific Cloud Storage Link
x-internal-id: data-tools-cloud-storage-links-{owner},{storage_link_name}-get
x-filename-id: data-tools-cloud-storage-links-owner-storage_link_name-get
delete:
description: Delete a Cloud Storage Link
operationId: deleteCloudStorageLink
tags:
- Data Tools
parameters:
- name: owner
in: path
description: Owner for the Cloud Storage Link.
required: true
schema:
type: string
- name: storage_link_name
in: path
description: Name of Cloud Storage Link to get
required: true
schema:
type: string
style: simple
responses:
'204':
description: Cloud Storage Link deleted
'404':
description: Cloud Storage Link not found
summary: Delete a Cloud Storage Link
x-internal-id: data-tools-cloud-storage-links-{owner},{storage_link_name}-delete
x-filename-id: data-tools-cloud-storage-links-owner-storage_link_name-delete
/data-tools/credentials/:
post:
description: Creates credentials
operationId: createCredentials
tags:
- Data Tools
parameters: []
requestBody:
$ref: '#/components/requestBodies/credentials'
responses:
'201':
description: Credentials were succesfully created
'204':
description: No content
'409':
description: Name conflict with existing Credential
summary: Creates credentials
x-internal-id: data-tools-credentials--post
x-filename-id: data-tools-credentials-post
get:
description: Gets credentials
operationId: getCredentials
tags:
- Data Tools
parameters: []
responses:
'200':
$ref: '#/components/responses/credentials'
'404':
description: No credentials found
summary: Gets credentials
x-internal-id: data-tools-credentials--get
x-filename-id: data-tools-credentials-get
/data-tools/credentials/{owner},{credential_name}:
get:
description: Gets specific credential
operationId: getCredential
tags:
- Data Tools
parameters:
- name: owner
in: path
description: Owner for the Credential.
required: true
schema:
type: string
- name: credential_name
in: path
description: Name of credential to get
required: true
schema:
type: string
style: simple
responses:
'200':
$ref: '#/components/responses/credentials'
'404':
description: Credential not found
summary: Gets specific credential
x-internal-id: data-tools-credentials-{owner},{credential_name}-get
x-filename-id: data-tools-credentials-owner-credential_name-get
delete:
description: Delete a credential
operationId: deleteCredential
tags:
- Data Tools
parameters:
- name: owner
in: path
description: Owner for the Credential.
required: true
schema:
type: string
- name: credential_name
in: path
description: Name of credential to delete
required: true
schema:
type: string
style: simple
responses:
'204':
description: Credential deleted
'404':
description: Credential not found
summary: Delete a credential
x-internal-id: data-tools-credentials-{owner},{credential_name}-delete
x-filename-id: data-tools-credentials-owner-credential_name-delete
components:
schemas:
object_filter_type:
type: string
description: Type of matching for object_filter
example: GLOB
enum:
- GLOB
- REGEX
cloud-storage-link:
type: object
properties:
storage_link_name:
$ref: '#/components/schemas/storage_link_name'
storage_link_description:
type: string
example: My bucket for CSV files
description: Description of Cloud Storage Link
credential_name:
type: string
example: MYCRED
description: Credential name used to access bucket
uri:
type: string
example: https://objectstorage.us-ashburn-1.oraclecloud.com/n/kdnmfs3kdj2x/b/my-bucket/o/
description: URI of bucket for Cloud Storage Links
sql_statements:
$ref: '#/components/schemas/sql_statements'
data_tools_job_name:
type: string
example: LOAD_AND_MODIFY_SALES
live-table-feeds:
type: object
properties:
live_table_feeds:
type: array
items:
$ref: '#/components/schemas/live-table-feed'
email-array:
type: array
example:
- data_studio_user@oracle.com
- oci_enthusiast@oracle.com
items:
description: Email address to notify
type: string
example: data_studio_user@oracle.com
data-load-job-id:
type: object
description: ID of data load job
properties:
data_load_job_id:
$ref: '#/components/schemas/data_load_job_id'
storage_link_name:
type: string
example: MY-BUCKET
description: Name of Cloud Storage Link
live_feed_object_type:
type: string
enum:
- CSV
- JSON
- XLSX
- IMAGE
- ICEBERG
cloud-storage-links:
type: object
properties:
cloud_storage_links:
type: array
items:
$ref: '#/components/schemas/cloud-storage-link'
data-tools-job-reporting-options:
type: object
properties:
smtp:
$ref: '#/components/schemas/email-array'
table_name:
type: string
example: SALES
description: Table name to load
data-tools-job-reporting:
type: object
properties:
completed:
$ref: '#/components/schemas/data-tools-job-reporting-options'
errors:
$ref: '#/components/schemas/data-tools-job-reporting-options'
failed:
$ref: '#/components/schemas/data-tools-job-reporting-options'
data_load_job_id:
type: string
example: SALES-LOAD-20220529-112233-4567
description: Name of data load job
data-load:
type: object
properties:
data_load_name:
$ref: '#/components/schemas/data_load_name'
data_load_job_id:
$ref: '#/components/schemas/data_load_job_id'
table_name:
$ref: '#/components/schemas/table_name'
table_schema:
$ref: '#/components/schemas/schema_name'
objects:
$ref: '#/components/schemas/data_load_objects'
storage_link_name:
$ref: '#/components/schemas/storage_link_name'
columns:
$ref: '#/components/schemas/columns'
object_filter:
$ref: '#/components/schemas/object_filter'
object_filter_type:
$ref: '#/components/schemas/object_filter_type'
partition_column_name:
type: string
example: FISCAL_YEAR
description: Column name to partition table on
format:
$ref: '#/components/schemas/format'
sql_statements:
$ref: '#/components/schemas/sql_statements'
merge_keys:
type: array
items:
type: string
description: Column name to merge on
example: '[ ''RECORD_ID'' ]'
table_exists_action:
type: string
example: APPEND
description: Action to take when there is an existing table.
enum:
- SKIP
- APPEND
- TRUNCATE
- MERGE
- REPLACE
target_type:
type: string
example: TABLE
description: Type of database object to create.
enum:
- TABLE
- EXTERNAL_TABLE
data_load_objects:
type: array
items:
$ref: '#/components/schemas/data_load_object'
example:
- object_name: sales1976.csv
- object_name: sales2009.csv
- object_name: sales2013.csv
credentials:
type: object
properties:
credentials:
type: array
items:
# --- truncated at 32 KB (48 KB total) ---
# Full source: https://raw.githubusercontent.com/api-evangelist/oracle-partitioning/refs/heads/main/openapi/oracle-partitioning-data-tools-api-openapi.yml