Oracle Partitioning Data Dictionary API

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&reg 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://&lt;server&gt;/&lt;context root&gt;/&lt;my database&gt;/&lt;my schema&gt;/_/db-api/stable/&lt;service path&gt;  </code>

    <p>Where, the <code>&lt;my database&gt;</code> and  <code>&lt;my schema&gt;</code> variables can be optional, depending on the ORDS configuration and the service invoked.'
  version: 2026.03.26
  title: Oracle REST Data Services Data Dictionary 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 Dictionary
  description: Services related to the tables and views that provide information about the database.
paths:
  /database/db_links/:
    get:
      tags:
      - Data Dictionary
      summary: Get all database links
      description: Describes all database links in the database. Uses DBA_DB_LINKS or ALL_DB_LINKS view depending on the role access at runtime. A client requires SQL Administrator or SQL Developer role to invoke this service.
      parameters:
      - $ref: '#/components/parameters/Limit'
      - $ref: '#/components/parameters/Filter'
      responses:
        '200':
          description: All database links in the database.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/DatabaseLinks'
      x-internal-id: database-db_links--get
      x-filename-id: database-db_links-get
  /database/db_links/{owner},{db_link}:
    get:
      tags:
      - Data Dictionary
      summary: Get a database link
      description: Describes a database link in the database. Uses DBA_DB_LINKS or ALL_DB_LINKS view depending on the role access at runtime. A client requires SQL Administrator or SQL Developer role to invoke this service.
      parameters:
      - name: owner
        in: path
        description: Owner for the database link.
        required: true
        schema:
          type: string
      - name: db_link
        in: path
        description: Name of the database link.
        required: true
        schema:
          type: string
      responses:
        '200':
          description: Information on the specific database link.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/DatabaseLinksItem'
      x-internal-id: database-db_links-{owner},{db_link}-get
      x-filename-id: database-db_links-owner-db_link-get
  /database/objects/:
    get:
      tags:
      - Data Dictionary
      summary: Get all database objects
      description: Returns all records from DBA_OBJECTS or ALL_OBJECTS depending on the role at runtime. A client requires SQL Administrator or SQL Developer role to invoke this service.
      parameters:
      - $ref: '#/components/parameters/Limit'
      - $ref: '#/components/parameters/Filter'
      responses:
        '200':
          description: All database objects in the database. Returns records from DBA_OBJECTS or ALL_OBJECTS.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/DatabaseObjects'
      x-internal-id: database-objects--get
      x-filename-id: database-objects-get
  /database/objects/{owner},{object_name},{object_type}:
    get:
      tags:
      - Data Dictionary
      summary: Get a specific object
      description: Returns the corresponding record from DBA_OBJECTS or ALL_OBJECTS view depending on the role at runtime. A client requires SQL Administrator or SQL Developer role to invoke this service.
      parameters:
      - name: owner
        in: path
        description: Owner for the index.
        required: true
        schema:
          type: string
      - name: object_name
        in: path
        description: Name of the object.
        required: true
        schema:
          type: string
      - name: object_type
        in: path
        description: Type of the object.
        required: true
        schema:
          type: string
      responses:
        '200':
          description: Information on a specific object.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/DatabaseObjectsItem'
      x-internal-id: database-objects-{owner},{object_name},{object_type}-get
      x-filename-id: database-objects-owner-object_name-object_type-get
  /database/objects/arguments/:
    get:
      tags:
      - Data Dictionary
      summary: Get all arguments for functions and procedures
      description: Returns all records from DBA_ARGUMENTS or ALL_ARGUMENTS view depending on role at runtime. A client requires SQL Administrator or SQL Developer role to invoke this service.
      parameters:
      - $ref: '#/components/parameters/Limit'
      - $ref: '#/components/parameters/Filter'
      responses:
        '200':
          description: All records from DBA_ARGUMENTS.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/DatabaseArguments'
      x-internal-id: database-objects-arguments--get
      x-filename-id: database-objects-arguments-get
  /database/objects/arguments/{object_id},{subprogram_id},{argument_name}:
    get:
      tags:
      - Data Dictionary
      summary: Get an argument
      description: Returns the specified argument information from DBA_ARGUMENTS or ALL_ARGUMENTS view depending on role at runtime. A client requires SQL Administrator or SQL Developer role to invoke this service.
      parameters:
      - name: object_id
        in: path
        description: Identifier of the object the argument belongs to.
        required: true
        schema:
          type: number
      - name: subprogram_id
        in: path
        description: Identifier of the subprogram the argument belongs to.
        required: true
        schema:
          type: number
      - name: argument_name
        in: path
        description: Name of the argument.
        required: true
        schema:
          type: string
      responses:
        '200':
          description: Information for the specified argument.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/DatabaseArgumentsItem'
      x-internal-id: database-objects-arguments-{object_id},{subprogram_id},{argument_name}-get
      x-filename-id: database-objects-arguments-object_id-subprogram_id-argument_name-get
  /database/objects/columns/:
    get:
      tags:
      - Data Dictionary
      summary: Get all table columns
      description: Returns all records from DBA_TAB_COLUMNS or ALL_TAB_COLUMNS view depending on role at runtime. Records included in the response describes the columns of all tables, views, and clusters that the role has access to. A client requires SQL Administrator or SQL Developer role to invoke this service.
      parameters:
      - $ref: '#/components/parameters/Limit'
      - $ref: '#/components/parameters/Filter'
      responses:
        '200':
          description: All columns in the database.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/DatabaseObjectsColumns'
      x-internal-id: database-objects-columns--get
      x-filename-id: database-objects-columns-get
  /database/objects/columns/{owner},{table_name},{column_name}:
    get:
      tags:
      - Data Dictionary
      summary: Get a specific column
      description: Returns the corresponding record from DBA_TAB_COLUMNS or ALL_TAB_COLUMNS view depending on role at runtime. A client requires SQL Administrator or SQL Developer role to invoke this service.
      parameters:
      - name: owner
        in: path
        description: Owner for the index.
        required: true
        schema:
          type: string
      - name: table_name
        in: path
        description: Name of the table the column belongs to.
        required: true
        schema:
          type: string
      - name: column_name
        in: path
        description: Name of the column.
        required: true
        schema:
          type: string
      responses:
        '200':
          description: Information on a specific column.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/DatabaseObjectsColumnsItem'
      x-internal-id: database-objects-columns-{owner},{table_name},{column_name}-get
      x-filename-id: database-objects-columns-owner-table_name-column_name-get
  /database/objects/foreign_keys/:
    get:
      tags:
      - Data Dictionary
      summary: Get all foreign keys
      description: Returns all records where the constraint type is 'R' from DBA_CONSTRAINTS and DBA_CONS_COLUMNS, or ALL_CONSTRAINTS and ALL_CONS_COLUMNS, views depending on role at runtime. A client requires SQL Administrator or SQL Developer role to invoke this service.
      parameters:
      - $ref: '#/components/parameters/Limit'
      - $ref: '#/components/parameters/Filter'
      responses:
        '200':
          description: Describes all constraint definitions, with constraint type 'R', on all tables in the database.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/DatabaseObjectsForeignKeys'
      x-internal-id: database-objects-foreign_keys--get
      x-filename-id: database-objects-foreign_keys-get
  /database/objects/foreign_keys/{owner},{constraint_name}:
    get:
      tags:
      - Data Dictionary
      summary: Get a specific foreign keys
      description: Returns the corresponding record from DBA_CONSTRAINTS and DBA_CONS_COLUMNS, or ALL_CONSTRAINTS and ALL_CONS_COLUMNS, views depending on role at runtime. Recorded included in the response are where the constraint type is 'R'. A client requires SQL Administrator or SQL Developer role to invoke this service.
      parameters:
      - name: owner
        in: path
        description: Owner for the foreign key.
        required: true
        schema:
          type: string
      - name: constraint_name
        in: path
        description: Name of the constraint for the foreign key.
        required: true
        schema:
          type: string
      responses:
        '200':
          description: Information on a specific foreign key.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/DatabaseObjectsForeignKeysItem'
      x-internal-id: database-objects-foreign_keys-{owner},{constraint_name}-get
      x-filename-id: database-objects-foreign_keys-owner-constraint_name-get
  /database/objects/functions/:
    get:
      tags:
      - Data Dictionary
      summary: Get all functions
      description: Returns records where OBJECT_TYPE = 'FUNCTION' from DBA_PROCEDURES or ALL_PROCEDURES view depending on role at runtime. A client requires SQL Administrator or SQL Developer role to invoke this service.
      parameters:
      - $ref: '#/components/parameters/Limit'
      - $ref: '#/components/parameters/Filter'
      responses:
        '200':
          description: Description of all functions in the database.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/DatabaseObjectsFunctions'
      x-internal-id: database-objects-functions--get
      x-filename-id: database-objects-functions-get
  /database/objects/functions/{object_id}:
    get:
      tags:
      - Data Dictionary
      summary: Get a specific function
      description: Returns the corresponding record from DBA_PROCEDURES or ALL_PROCEDURES view depending on role at runtime. Records included in the response are where OBJECT_TYPE = 'FUNCTION'. A client requires SQL Administrator or SQL Developer role to invoke this service.
      parameters:
      - name: object_id
        in: path
        description: Object Identifier for the function.
        required: true
        schema:
          type: string
      responses:
        '200':
          description: Information for the specified function.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/DatabaseObjectsFunctionsItem'
      x-internal-id: database-objects-functions-{object_id}-get
      x-filename-id: database-objects-functions-object_id-get
  /database/objects/indexes/:
    get:
      tags:
      - Data Dictionary
      summary: Get all indexes
      description: Describes all the indexes in the database using DBA_INDEXES or ALL_INDEXES view depending on role at runtime. A client requires SQL Administrator or SQL Developer role to invoke this service.
      parameters:
      - $ref: '#/components/parameters/Limit'
      - $ref: '#/components/parameters/Filter'
      responses:
        '200':
          description: Description of all indexes in the database.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/DatabaseObjectsIndexes'
      x-internal-id: database-objects-indexes--get
      x-filename-id: database-objects-indexes-get
  /database/objects/indexes/{owner},{index_name}:
    get:
      tags:
      - Data Dictionary
      summary: Get a specific index
      description: Returns the corresponding record from DBA_INDEXES or ALL_INDEXES view depending on role at runtime. A client requires SQL Administrator or SQL Developer role to invoke this service.
      parameters:
      - name: owner
        in: path
        description: Owner for the index.
        required: true
        schema:
          type: string
      - name: index_name
        in: path
        description: Name of the index.
        required: true
        schema:
          type: string
      responses:
        '200':
          description: Information on a specific index.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/DatabaseObjectsIndexesItem'
      x-internal-id: database-objects-indexes-{owner},{index_name}-get
      x-filename-id: database-objects-indexes-owner-index_name-get
  /database/objects/materialized_view_logs/:
    get:
      tags:
      - Data Dictionary
      summary: Get all materialized view logs
      description: Returns all records from DBA_MVIEW_LOGS or ALL_MVIEW_LOGS view depending on role at runtime. A client requires SQL Administrator or SQL Developer role to invoke this service.
      parameters:
      - $ref: '#/components/parameters/Limit'
      - $ref: '#/components/parameters/Filter'
      responses:
        '200':
          description: All records from DBA_MVIEW_LOGS.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/DatabaseObjectsMaterializedViewLogs'
      x-internal-id: database-objects-materialized_view_logs--get
      x-filename-id: database-objects-materialized_view_logs-get
  /database/objects/materialized_view_logs/{log_owner},{log_table}:
    get:
      tags:
      - Data Dictionary
      summary: Get information on a specific materialized view log
      description: Returns the corresponding record from DBA_MVIEW_LOGS or ALL_MVIEW_LOGS view depending on role at runtime. A client requires SQL Administrator or SQL Developer role to invoke this service.
      parameters:
      - name: log_owner
        in: path
        description: Owner for the materialized view log.
        required: true
        schema:
          type: string
      - name: log_table
        in: path
        description: Log table for the materialized view log.
        required: true
        schema:
          type: string
      responses:
        '200':
          description: Information on a specific materialized view log.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/DatabaseObjectsMaterializedViewLogsItem'
      x-internal-id: database-objects-materialized_view_logs-{log_owner},{log_table}-get
      x-filename-id: database-objects-materialized_view_logs-log_owner-log_table-get
  /database/objects/packages/procedures/:
    get:
      tags:
      - Data Dictionary
      summary: Get all procedures defined in package
      description: Returns all records from DBA_PROCEDURES or ALL_PROCEDURES view depending on role at runtime. Records included in the response are where OBJECT_TYPE = 'PACKAGE' and PROCEDURE_NAME is not null. A client requires SQL Administrator or SQL Developer role to invoke this service.
      parameters:
      - $ref: '#/components/parameters/Limit'
      - $ref: '#/components/parameters/Filter'
      responses:
        '200':
          description: Describes all procedures that are defined in a package.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/DatabaseObjectsProcedures'
      x-internal-id: database-objects-packages-procedures--get
      x-filename-id: database-objects-packages-procedures-get
  /database/objects/packages/procedures/{object_id},{subprogram_id}:
    get:
      tags:
      - Data Dictionary
      summary: Get a procedure that is defined in package
      description: Returns the corresponding record from DBA_PROCEDURES or ALL_PROCEDURES view depending on role at runtime. Records included in the response are where OBJECT_TYPE = 'PACKAGE' and PROCEDURE_NAME is not null. A client requires SQL Administrator or SQL Developer role to invoke this service.
      parameters:
      - name: object_id
        in: path
        description: Object identifier for the package the procedure belongs to.
        required: true
        schema:
          type: number
      - name: subprogram_id
        in: path
        description: Subprogram identifier for the procedure.
        required: true
        schema:
          type: number
      responses:
        '200':
          description: Information on the specified procedure.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/DatabaseObjectsProceduresItem'
      x-internal-id: database-objects-packages-procedures-{object_id},{subprogram_id}-get
      x-filename-id: database-objects-packages-procedures-object_id-subprogram_id-get
  /database/objects/partitions/:
    get:
      tags:
      - Data Dictionary
      summary: Get all partitions in the database
      description: Returns all records from DBA_TAB_PARTITIONS or ALL_TAB_PARTITIONS view depending on role at runtime. A client requires SQL Administrator or SQL Developer role to invoke this service.
      parameters:
      - $ref: '#/components/parameters/Limit'
      - $ref: '#/components/parameters/Filter'
      responses:
        '200':
          description: Description of all partitions in the database.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/DatabaseObjectsPartitions'
      x-internal-id: database-objects-partitions--get
      x-filename-id: database-objects-partitions-get
  /database/objects/partitions/{table_owner},{table_name},{partition_name}:
    get:
      tags:
      - Data Dictionary
      summary: Get a partition
      description: Returns the specified partition information from DBA_TAB_PARTITIONS or ALL_TAB_PARTITIONS view depending on role at runtime. A client requires SQL Administrator or SQL Developer role to invoke this service.
      parameters:
      - name: table_owner
        in: path
        description: Owner for the index.
        required: true
        schema:
          type: string
      - name: table_name
        in: path
        description: Name of the table.
        required: true
        schema:
          type: string
      - name: partition_name
        in: path
        description: Name of the partition.
        required: true
        schema:
          type: string
      responses:
        '200':
          description: Information for the specified partition.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/DatabaseObjectsPartitionsItem'
      x-internal-id: database-objects-partitions-{table_owner},{table_name},{partition_name}-get
      x-filename-id: database-objects-partitions-table_owner-table_name-partition_name-get
  /database/objects/synonyms/:
    get:
      tags:
      - Data Dictionary
      summary: Get all synonyms in the database
      description: Returns all records on DBA_SYNONYMS or ALL_SYNONYMS view depending on role at runtime. A client requires SQL Administrator or SQL Developer role to invoke this service.
      parameters:
      - $ref: '#/components/parameters/Limit'
      - $ref: '#/components/parameters/Filter'
      responses:
        '200':
          description: Describes, using DBA_SYNONYMS or ALL_SYNONYMS view, all synonyms in the database.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/DatabaseObjectsSynonyms'
      x-internal-id: database-objects-synonyms--get
      x-filename-id: database-objects-synonyms-get
  /database/objects/synonyms/{owner},{synonym_name}:
    get:
      tags:
      - Data Dictionary
      summary: Get a synonym
      description: Returns a record from DBA_SYNONYMS or ALL_SYNONYMS view depending on role at runtime. A client requires SQL Administrator or SQL Developer role to invoke this service.
      parameters:
      - name: owner
        in: path
        description: Owner of the synonym.
        required: true
        schema:
          type: string
      - name: synonym_name
        in: path
        description: Name of the synonym.
        required: true
        schema:
          type: string
      responses:
        '200':
          description: Information on a specific synonym.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/DatabaseObjectsSynonymsItem'
      x-internal-id: database-objects-synonyms-{owner},{synonym_name}-get
      x-filename-id: database-objects-synonyms-owner-synonym_name-get
  /database/objects/tables/:
    get:
      tags:
      - Data Dictionary
      summary: Get all tables
      description: Describes all the tables in the database using DBA_TABLES or ALL_TABLES view depending on role at runtime. A client requires SQL Administrator or SQL Developer role to invoke this service.
      parameters:
      - $ref: '#/components/parameters/Limit'
      - $ref: '#/components/parameters/Filter'
      responses:
        '200':
          description: All tables in the database.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/DatabaseObjectsTables'
      x-internal-id: database-objects-tables--get
      x-filename-id: database-objects-tables-get
  /database/objects/tables/{owner},{table_name}:
    get:
      tags:
      - Data Dictionary
      summary: Get a specific table
      description: Describes a specific table in the database using DBA_TABLES or ALL_TABLES view depending on role at runtime. A client requires SQL Administrator or SQL Developer role to invoke this service.
      parameters:
      - name: owner
        in: path
        description: Owner of the table.
        required: true
        schema:
          type: string
      - name: table_name
        in: path
        description: Name of the table.
        required: true
        schema:
          type: string
      responses:
        '200':
          description: All tables in the database.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/DatabaseObjectsTablesItem'
      x-internal-id: database-objects-tables-{owner},{table_name}-get
      x-filename-id: database-objects-tables-owner-table_name-get
  /database/tablespaces/:
    get:
      tags:
      - Data Dictionary
      summary: Get all tablespaces
      description: Describes all the tablespaces in the database using DBA_TABLESPACES or USER_TABLESPACES view depending on role at runtime. A client requires SQL Administrator or SQL Developer role to invoke this service.
      parameters:
      - $ref: '#/components/parameters/Limit'
      - $ref: '#/components/parameters/Filter'
      responses:
        '200':
          description: All tablespaces in the database.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/DatabaseTablespaces'
      x-internal-id: database-tablespaces--get
      x-filename-id: database-tablespaces-get
  /database/tablespaces/{tablespace_name}:
    get:
      tags:
      - Data Dictionary
      summary: Get a specific tablespace
      description: Describes a specific tablespace in the database using DBA_TABLESPACES or USER_TABLESPACES view depending on role at runtime. A client requires SQL Administrator or SQL Developer role to invoke this service.
      parameters:
      - name: tablespace_name
        in: path
        description: Name of the tablespace.
        required: true
        schema:
          type: string
      responses:
        '200':
          description: All tablespaces in the database.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/DatabaseTablespacesItem'
      x-internal-id: database-tablespaces-{tablespace_name}-get
      x-filename-id: database-tablespaces-tablespace_name-get
  /database/objects/types/:
    get:
      tags:
      - Data Dictionary
      summary: Get all object types
      description: Describes all object types in the database. Uses DBA_TYPES or ALL_TYPES view depending on role at runtime. A client requires SQL Administrator or SQL Developer role to invoke this service.
      parameters:
      - $ref: '#/components/parameters/Limit'
      - $ref: '#/components/parameters/Filter'
      responses:
        '200':
          description: Description of all object types in the database.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/DatabaseObjectsTypes'
      x-internal-id: database-objects-types--get
      x-filename-id: database-objects-types-get
  /database/objects/types/{owner},{type_name}:
    get:
      tags:
      - Data Dictionary
      summary: Get an object type
      description: Describes a specific object type in the database. Uses DBA_TYPES or ALL_TYPES view depending on role at runtime. A client requires SQL Administrator or SQL Developer role to invoke this service.
      parameters:
      - name: owner
        in: path
        description: Owner of the type.
        required: true
        schema:
          type: string
      - name: type_name
        in: path
        description: Name of the type.
        required: true
        schema:
          type: string
      responses:
        '200':
          description: Information on a specific object type.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/DatabaseObjectsTypesItem'
      x-internal-id: database-objects-types-{owner},{type_name}-get
      x-filename-id: database-objects-types-owner-type_name-get
components:
  schemas:
    DatabaseArgumentsItem:
      type: object
      description: This object represents arguments of the functions and procedures that are available in the database. The list of attributes may vary depending on database version.
      properties:
        owner:
          type: string
          description: Owner of the object.
        object_name:
          type: string
          description: Name of the procedure or function.
        package_name:
          type: string
          description: Name of the package.
        object_id:
          type: integer
          description: Dictionary object number of the object.
        overload:
          type: string
          description: Indicates the nth overloading ordered by its appearance in the source; otherwise, it is NULL.
        subprogram_id:
          type: integer
          description: Unique subprogram identifier.
        argument_name:
          type: string
          description: If the argument is a scalar type, then the argument name is the name of the argument. A null argument name is used to denote a function return. If the function return or argument is a composite type, this view will have one row for each attribute of the composite type. Attributes are recursively expanded if they are composite.
        position:
          type: integer
          description: If DATA_LEVEL is zero, then this column holds the position of this item in the argument list, or zero for a function return value.If DATA_LEVEL is greater than zero, then this column holds the position of this item with respect to its siblings at the same DATA_LEVEL. So, for a referenced record field, this is the index of the field within the record. For a referenced collection element, this is 1 (because collection elements do not have siblings.)
        sequence:
          type: integer
          description: Defines the sequential order of the argument and its attributes. Argument sequence starts from 1. Return type and its recursively expanded (preorder tree walk) attributes will come first, and each argument with its recursively expanded (preorder tree walk) attributes will follow.
        data_level:
          type: integer
          description: Nesting depth of the argument for composite types.
        data_type:
          type: string
          description: Datatype of the argument.
        defaulted:
          type: string
          description: Specifies whether or not the argument is defaulted.
        default_value:
          type: integer
          description: Reserved for future use.
        default_length:
          type: integer
          description: Reserved for future use.
        in_out:
          type: string
          description: 'Direction of the argument: IN, OUT, IN/OUT.'
        data_length:
          type: integer
          description: Length of the column (in bytes).
        data_precision:
          type: integer
          description: Length in decimal digits (NUMBER) or binary digits (FLOAT).
        data_scale:
          type: integer
          description: Digits to the right of the decimal point in a number.
        radix:
          type: integer
          description: Argument radix for a number.
        character_set_name:
          type: string
          description: Character set name for the argument.
        type_owner:
          type: string
          description: Owner of the type of the argument.
        type_name:
          type: string
          description: Name of the type of the argument. If the type is a package local type (that is, it is declared in a package specification), then this column displays the name of the package.
        type_subname:
          type: string
          description: Relevant only for package local types. Displays the name of the type declared in the package identified in the TYPE_NAME column.
        type_link:
          type: string
          description: Relevant only for package local types when the package identified in the TYPE_NAME column is a remote package. This column displays the database link used to refer to the remote package.
        type_object_type:
          type: string
          description: Displays the type of the type described by the TYPE_OWNER, TYPE_NAME, and TYPE_SUBNAME columns.
        pls_type:
          

# --- truncated at 32 KB (99 KB total) ---
# Full source: https://raw.githubusercontent.com/api-evangelist/oracle-partitioning/refs/heads/main/openapi/oracle-partitioning-data-dictionary-api-openapi.yml