Oracle Database · JSON Structure

Oracle Database Structure

Structural overview of the Oracle Database API surface; extracted from openapi/.

Type: Properties: 0
CloudDatabaseEnterpriseOracleREST APISQL

Oracle Database Structure is a JSON Structure definition published by Oracle Database.

Meta-schema:

JSON Structure

Raw ↑
{
  "provider": "Oracle Database",
  "providerId": "oracle-database",
  "kind": "json-structure",
  "description": "Structural overview of the Oracle Database API surface; extracted from openapi/.",
  "schemaCount": 85,
  "operationCount": 101,
  "schemas": [
    {
      "name": "Error",
      "type": "object",
      "propertyCount": 3,
      "required": []
    },
    {
      "name": "PaginatedResponse",
      "type": "object",
      "propertyCount": 6,
      "required": []
    },
    {
      "name": "Link",
      "type": "object",
      "propertyCount": 2,
      "required": []
    },
    {
      "name": "DatabaseStatus",
      "type": "object",
      "propertyCount": 5,
      "required": []
    },
    {
      "name": "DatabaseVersion",
      "type": "object",
      "propertyCount": 3,
      "required": []
    },
    {
      "name": "ComponentList",
      "type": "object",
      "propertyCount": 1,
      "required": []
    },
    {
      "name": "ParameterList",
      "type": null,
      "propertyCount": 0,
      "required": []
    },
    {
      "name": "DatabaseParameter",
      "type": "object",
      "propertyCount": 7,
      "required": []
    },
    {
      "name": "UserList",
      "type": "object",
      "propertyCount": 1,
      "required": []
    },
    {
      "name": "StorageInfo",
      "type": "object",
      "propertyCount": 3,
      "required": []
    },
    {
      "name": "TablespaceList",
      "type": "object",
      "propertyCount": 1,
      "required": []
    },
    {
      "name": "Tablespace",
      "type": "object",
      "propertyCount": 7,
      "required": []
    },
    {
      "name": "DatafileList",
      "type": "object",
      "propertyCount": 1,
      "required": []
    },
    {
      "name": "FeatureUsageList",
      "type": "object",
      "propertyCount": 1,
      "required": []
    },
    {
      "name": "SessionlessTransaction",
      "type": "object",
      "propertyCount": 1,
      "required": []
    },
    {
      "name": "TableList",
      "type": null,
      "propertyCount": 0,
      "required": []
    },
    {
      "name": "TableMetadata",
      "type": "object",
      "propertyCount": 7,
      "required": []
    },
    {
      "name": "ColumnList",
      "type": null,
      "propertyCount": 0,
      "required": []
    },
    {
      "name": "ColumnMetadata",
      "type": "object",
      "propertyCount": 7,
      "required": []
    },
    {
      "name": "IndexList",
      "type": "object",
      "propertyCount": 1,
      "required": []
    },
    {
      "name": "IndexMetadata",
      "type": "object",
      "propertyCount": 6,
      "required": []
    },
    {
      "name": "FunctionList",
      "type": "object",
      "propertyCount": 1,
      "required": []
    },
    {
      "name": "FunctionMetadata",
      "type": "object",
      "propertyCount": 5,
      "required": []
    },
    {
      "name": "ForeignKeyList",
      "type": "object",
      "propertyCount": 1,
      "required": []
    },
    {
      "name": "DatabaseLinkList",
      "type": "object",
      "propertyCount": 1,
      "required": []
    },
    {
      "name": "DatabaseLink",
      "type": "object",
      "propertyCount": 5,
      "required": []
    },
    {
      "name": "SessionList",
      "type": null,
      "propertyCount": 0,
      "required": []
    },
    {
      "name": "SessionDetail",
      "type": "object",
      "propertyCount": 10,
      "required": []
    },
    {
      "name": "SessionLockList",
      "type": "object",
      "propertyCount": 1,
      "required": []
    },
    {
      "name": "AlertList",
      "type": "object",
      "propertyCount": 1,
      "required": []
    },
    {
      "name": "AlertSummaryList",
      "type": "object",
      "propertyCount": 1,
      "required": []
    },
    {
      "name": "WaitClassMetricList",
      "type": "object",
      "propertyCount": 1,
      "required": []
    },
    {
      "name": "WaitClassTotalList",
      "type": "object",
      "propertyCount": 1,
      "required": []
    },
    {
      "name": "SessionLimitList",
      "type": "object",
      "propertyCount": 1,
      "required": []
    },
    {
      "name": "SQLStatementList",
      "type": null,
      "propertyCount": 0,
      "required": []
    },
    {
      "name": "SQLStatementDetail",
      "type": "object",
      "propertyCount": 8,
      "required": []
    },
    {
      "name": "SQLText",
      "type": "object",
      "propertyCount": 2,
      "required": []
    },
    {
      "name": "ExecutionPlan",
      "type": "object",
      "propertyCount": 3,
      "required": []
    },
    {
      "name": "SQLHistoryList",
      "type": "object",
      "propertyCount": 1,
      "required": []
    },
    {
      "name": "ActiveSessionHistoryList",
      "type": "object",
      "propertyCount": 1,
      "required": []
    },
    {
      "name": "ActiveSessionWaitList",
      "type": "object",
      "propertyCount": 1,
      "required": []
    },
    {
      "name": "PDBList",
      "type": "object",
      "propertyCount": 1,
      "required": []
    },
    {
      "name": "PDB",
      "type": "object",
      "propertyCount": 6,
      "required": []
    },
    {
      "name": "CreatePDBRequest",
      "type": "object",
      "propertyCount": 5,
      "required": [
        "pdb_name",
        "admin_username",
        "admin_password"
      ]
    },
    {
      "name": "UpdatePDBRequest",
      "type": "object",
      "propertyCount": 2,
      "required": []
    },
    {
      "name": "SnapshotList",
      "type": "object",
      "propertyCount": 1,
      "required": []
    },
    {
      "name": "Snapshot",
      "type": "object",
      "propertyCount": 4,
      "required": []
    },
    {
      "name": "AutoSnapshotConfig",
      "type": "object",
      "propertyCount": 3,
      "required": []
    },
    {
      "name": "SnapshotMode",
      "type": "object",
      "propertyCount": 1,
      "required": []
    },
    {
      "name": "DataGuardConfiguration",
      "type": "object",
      "propertyCount": 4,
      "required": []
    },
    {
      "name": "CreateDataGuardConfigRequest",
      "type": "object",
      "propertyCount": 2,
      "required": [
        "configuration_name"
      ]
    },
    {
      "name": "UpdateDataGuardConfigRequest",
      "type": "object",
      "propertyCount": 2,
      "required": []
    },
    {
      "name": "DataGuardDatabaseList",
      "type": "object",
      "propertyCount": 1,
      "required": []
    },
    {
      "name": "DataGuardDatabase",
      "type": "object",
      "propertyCount": 5,
      "required": []
    },
    {
      "name": "AddDataGuardDatabaseRequest",
      "type": "object",
      "propertyCount": 2,
      "required": [
        "database_name",
        "connect_identifier"
      ]
    },
    {
      "name": "UpdateDataGuardDatabaseRequest",
      "type": "object",
      "propertyCount": 1,
      "required": []
    },
    {
      "name": "DataPumpExportRequest",
      "type": "object",
      "propertyCount": 6,
      "required": [
        "job_name"
      ]
    },
    {
      "name": "DataPumpImportRequest",
      "type": "object",
      "propertyCount": 5,
      "required": [
        "job_name"
      ]
    },
    {
      "name": "DataPumpJob",
      "type": "object",
      "propertyCount": 7,
      "required": []
    },
    {
      "name": "DataPumpJobList",
      "type": "object",
      "propertyCount": 1,
      "required": []
    },
    {
      "name": "RESTModuleList",
      "type": "object",
      "propertyCount": 1,
      "required": []
    },
    {
      "name": "RESTModule",
      "type": "object",
      "propertyCount": 5,
      "required": []
    },
    {
      "name": "CreateRESTModuleRequest",
      "type": "object",
      "propertyCount": 4,
      "required": [
        "name",
        "uri_prefix"
      ]
    },
    {
      "name": "RESTHandlerList",
      "type": "object",
      "propertyCount": 1,
      "required": []
    },
    {
      "name": "CreateRESTHandlerRequest",
      "type": "object",
      "propertyCount": 3,
      "required": [
        "method",
        "source_type",
        "source"
      ]
    },
    {
      "name": "OAuthClientList",
      "type": "object",
      "propertyCount": 1,
      "required": []
    },
    {
      "name": "CreateOAuthClientRequest",
      "type": "object",
      "propertyCount": 4,
      "required": [
        "name",
        "grant_type"
      ]
    },
    {
      "name": "CreatePrivilegeRequest",
      "type": "object",
      "propertyCount": 4,
      "required": [
        "name",
        "label"
      ]
    },
    {
      "name": "CreateRoleRequest",
      "type": "object",
      "propertyCount": 2,
      "required": [
        "name"
      ]
    },
    {
      "name": "AutoRESTRequest",
      "type": "object",
      "propertyCount": 4,
      "required": [
        "object_name",
        "object_type"
      ]
    },
    {
      "name": "ORDSPropertyList",
      "type": "object",
      "propertyCount": 1,
      "required": []
    },
    {
      "name": "ORDSPropertyValue",
      "type": "object",
      "propertyCount": 1,
      "required": []
    },
    {
      "name": "SchedulerJobList",
      "type": "object",
      "propertyCount": 1,
      "required": []
    },
    {
      "name": "SchedulerJob",
      "type": "object",
      "propertyCount": 8,
      "required": []
    },
    {
      "name": "APEXWorkspaceList",
      "type": "object",
      "propertyCount": 1,
      "required": []
    },
    {
      "name": "APEXWorkspace",
      "type": "object",
      "propertyCount": 3,
      "required": []
    },
    {
      "name": "APEXApplicationList",
      "type": "object",
      "propertyCount": 1,
      "required": []
    },
    {
      "name": "APEXApplicationRequest",
      "type": "object",
      "propertyCount": 2,
      "required": []
    },
    {
      "name": "APEXOverview",
      "type": "object",
      "propertyCount": 3,
      "required": []
    },
    {
      "name": "RDFNetworkList",
      "type": "object",
      "propertyCount": 1,
      "required": []
    },
    {
      "name": "RDFNetwork",
      "type": "object",
      "propertyCount": 2,
      "required": []
    },
    {
      "name": "RDFModelList",
      "type": "object",
      "propertyCount": 1,
      "required": []
    },
    {
      "name": "SPARQLResults",
      "type": "object",
      "propertyCount": 2,
      "required": []
    },
    {
      "name": "ServiceCatalog",
      "type": "object",
      "propertyCount": 1,
      "required": []
    },
    {
      "name": "ProvisionRequest",
      "type": "object",
      "propertyCount": 3,
      "required": [
        "service_id",
        "plan_id"
      ]
    }
  ],
  "operations": [
    {
      "method": "GET",
      "path": "/database/status",
      "operationId": "getDatabaseStatus",
      "summary": "Oracle Database Get database status",
      "tags": [
        "General"
      ]
    },
    {
      "method": "GET",
      "path": "/database/version",
      "operationId": "getDatabaseVersion",
      "summary": "Oracle Database Get database version",
      "tags": [
        "General"
      ]
    },
    {
      "method": "GET",
      "path": "/database/components/",
      "operationId": "getDatabaseComponents",
      "summary": "Oracle Database Get all database components",
      "tags": [
        "General"
      ]
    },
    {
      "method": "GET",
      "path": "/database/parameters/",
      "operationId": "getDatabaseParameters",
      "summary": "Oracle Database Get all database parameters",
      "tags": [
        "General"
      ]
    },
    {
      "method": "GET",
      "path": "/database/parameters/{name}",
      "operationId": "getDatabaseParameter",
      "summary": "Oracle Database Get a specific database parameter",
      "tags": [
        "General"
      ]
    },
    {
      "method": "GET",
      "path": "/database/security/users/",
      "operationId": "getDatabaseUsers",
      "summary": "Oracle Database Get all database users",
      "tags": [
        "General"
      ]
    },
    {
      "method": "GET",
      "path": "/database/storage/bytes",
      "operationId": "getStorageBytes",
      "summary": "Oracle Database Get storage usage in bytes",
      "tags": [
        "General"
      ]
    },
    {
      "method": "GET",
      "path": "/database/storage/tablespaces/",
      "operationId": "getTablespaces",
      "summary": "Oracle Database Get all tablespaces storage information",
      "tags": [
        "General"
      ]
    },
    {
      "method": "GET",
      "path": "/database/storage/tablespaces/{tablespace_name}/",
      "operationId": "getTablespace",
      "summary": "Oracle Database Get tablespace details",
      "tags": [
        "General"
      ]
    },
    {
      "method": "GET",
      "path": "/database/storage/tablespaces/{tablespace_name}/datafiles/",
      "operationId": "getDatafiles",
      "summary": "Oracle Database Get tablespace datafiles",
      "tags": [
        "General"
      ]
    },
    {
      "method": "GET",
      "path": "/database/feature_usage/",
      "operationId": "getFeatureUsage",
      "summary": "Oracle Database Get feature usage statistics",
      "tags": [
        "General"
      ]
    },
    {
      "method": "POST",
      "path": "/database/sessionless-transactions/",
      "operationId": "startSessionlessTransaction",
      "summary": "Oracle Database Start a sessionless transaction",
      "tags": [
        "General"
      ]
    },
    {
      "method": "PUT",
      "path": "/database/sessionless-transactions/{sessionlessTransactionID}",
      "operationId": "commitSessionlessTransaction",
      "summary": "Oracle Database Commit a sessionless transaction",
      "tags": [
        "General"
      ]
    },
    {
      "method": "DELETE",
      "path": "/database/sessionless-transactions/{sessionlessTransactionID}",
      "operationId": "rollbackSessionlessTransaction",
      "summary": "Oracle Database Rollback a sessionless transaction",
      "tags": [
        "General"
      ]
    },
    {
      "method": "GET",
      "path": "/database/objects/tables/",
      "operationId": "getTables",
      "summary": "Oracle Database Get all tables",
      "tags": [
        "Data Dictionary"
      ]
    },
    {
      "method": "GET",
      "path": "/database/objects/tables/{owner},{table_name}",
      "operationId": "getTable",
      "summary": "Oracle Database Get a specific table",
      "tags": [
        "Data Dictionary"
      ]
    },
    {
      "method": "GET",
      "path": "/database/objects/columns/",
      "operationId": "getColumns",
      "summary": "Oracle Database Get all table columns",
      "tags": [
        "Data Dictionary"
      ]
    },
    {
      "method": "GET",
      "path": "/database/objects/columns/{owner},{table_name},{column_name}",
      "operationId": "getColumn",
      "summary": "Oracle Database Get a specific column",
      "tags": [
        "Data Dictionary"
      ]
    },
    {
      "method": "GET",
      "path": "/database/objects/indexes/",
      "operationId": "getIndexes",
      "summary": "Oracle Database Get all indexes",
      "tags": [
        "Data Dictionary"
      ]
    },
    {
      "method": "GET",
      "path": "/database/objects/indexes/{owner},{index_name}",
      "operationId": "getIndex",
      "summary": "Oracle Database Get a specific index",
      "tags": [
        "Data Dictionary"
      ]
    },
    {
      "method": "GET",
      "path": "/database/objects/functions/",
      "operationId": "getFunctions",
      "summary": "Oracle Database Get all functions",
      "tags": [
        "Data Dictionary"
      ]
    },
    {
      "method": "GET",
      "path": "/database/objects/functions/{object_id}",
      "operationId": "getFunction",
      "summary": "Oracle Database Get a specific function",
      "tags": [
        "Data Dictionary"
      ]
    },
    {
      "method": "GET",
      "path": "/database/objects/foreign_keys/",
      "operationId": "getForeignKeys",
      "summary": "Oracle Database Get all foreign keys",
      "tags": [
        "Data Dictionary"
      ]
    },
    {
      "method": "GET",
      "path": "/database/db_links/",
      "operationId": "getDatabaseLinks",
      "summary": "Oracle Database Get all database links",
      "tags": [
        "Data Dictionary"
      ]
    },
    {
      "method": "GET",
      "path": "/database/db_links/{owner},{db_link}",
      "operationId": "getDatabaseLink",
      "summary": "Oracle Database Get a specific database link",
      "tags": [
        "Data Dictionary"
      ]
    },
    {
      "method": "GET",
      "path": "/database/tablespaces/",
      "operationId": "getTablespacesDict",
      "summary": "Oracle Database Get all tablespaces",
      "tags": [
        "Data Dictionary"
      ]
    },
    {
      "method": "GET",
      "path": "/database/monitoring/sessions/",
      "operationId": "getSessions",
      "summary": "Oracle Database Get all sessions",
      "tags": [
        "Monitoring"
      ]
    },
    {
      "method": "GET",
      "path": "/database/monitoring/sessions/{sid},{serial_number}/",
      "operationId": "getSession",
      "summary": "Oracle Database Get a specific session",
      "tags": [
        "Monitoring"
      ]
    },
    {
      "method": "GET",
      "path": "/database/monitoring/session_locks/",
      "operationId": "getSessionLocks",
      "summary": "Oracle Database Get all session locks",
      "tags": [
        "Monitoring"
      ]
    },
    {
      "method": "GET",
      "path": "/database/monitoring/session_locks/holding/",
      "operationId": "getBlockingLocks",
      "summary": "Oracle Database Get blocking locks",
      "tags": [
        "Monitoring"
      ]
    },
    {
      "method": "GET",
      "path": "/database/monitoring/session_locks/waiting/",
      "operationId": "getWaitingLocks",
      "summary": "Oracle Database Get waiting locks",
      "tags": [
        "Monitoring"
      ]
    },
    {
      "method": "GET",
      "path": "/database/monitoring/alerts/",
      "operationId": "getAlerts",
      "summary": "Oracle Database Get all alerts",
      "tags": [
        "Monitoring"
      ]
    },
    {
      "method": "GET",
      "path": "/database/monitoring/alerts_summaries/by_message_level",
      "operationId": "getAlertSummaries",
      "summary": "Oracle Database Get alert summaries by message level",
      "tags": [
        "Monitoring"
      ]
    },
    {
      "method": "GET",
      "path": "/database/monitoring/wait_class_metrics",
      "operationId": "getWaitClassMetrics",
      "summary": "Oracle Database Get wait class metrics",
      "tags": [
        "Monitoring"
      ]
    },
    {
      "method": "GET",
      "path": "/database/monitoring/wait_class_totals",
      "operationId": "getWaitClassTotals",
      "summary": "Oracle Database Get wait class totals",
      "tags": [
        "Monitoring"
      ]
    },
    {
      "method": "GET",
      "path": "/database/monitoring/session_limits",
      "operationId": "getSessionLimits",
      "summary": "Oracle Database Get session limits",
      "tags": [
        "Monitoring"
      ]
    },
    {
      "method": "GET",
      "path": "/database/performance/sql_statements/",
      "operationId": "getSQLStatements",
      "summary": "Oracle Database Get all SQL statements",
      "tags": [
        "Performance"
      ]
    },
    {
      "method": "GET",
      "path": "/database/performance/top_sql_statements/",
      "operationId": "getTopSQLStatements",
      "summary": "Oracle Database Get top SQL by CPU usage",
      "tags": [
        "Performance"
      ]
    },
    {
      "method": "GET",
      "path": "/database/performance/sql_statements/{sql_id}/",
      "operationId": "getSQLStatementStats",
      "summary": "Oracle Database Get SQL statement statistics",
      "tags": [
        "Performance"
      ]
    },
    {
      "method": "GET",
      "path": "/database/performance/sql_statements/{sql_id}/text",
      "operationId": "getSQLStatementText",
      "summary": "Oracle Database Get SQL statement text",
      "tags": [
        "Performance"
      ]
    },
    {
      "method": "GET",
      "path": "/database/performance/sql_statements/{sql_id}/plan",
      "operationId": "getSQLExecutionPlan",
      "summary": "Oracle Database Get SQL execution plan",
      "tags": [
        "Performance"
      ]
    },
    {
      "method": "GET",
      "path": "/database/performance/sql_statements/{sql_id}/history",
      "operationId": "getSQLHistory",
      "summary": "Oracle Database Get SQL statement history",
      "tags": [
        "Performance"
      ]
    },
    {
      "method": "GET",
      "path": "/database/performance/active_sessions_history/",
      "operationId": "getActiveSessionsHistory",
      "summary": "Oracle Database Get active sessions history",
      "tags": [
        "Performance"
      ]
    },
    {
      "method": "GET",
      "path": "/database/performance/active_sessions_history_waits/",
      "operationId": "getActiveSessionsHistoryWaits",
      "summary": "Oracle Database Get active session history waits",
      "tags": [
        "Performance"
      ]
    },
    {
      "method": "GET",
      "path": "/database/pdbs/",
      "operationId": "getPDBs",
      "summary": "Oracle Database Get all pluggable databases",
      "tags": [
        "Pluggable Databases"
      ]
    },
    {
      "method": "POST",
      "path": "/database/pdbs/",
      "operationId": "createPDB",
      "summary": "Oracle Database Create a pluggable database",
      "tags": [
        "Pluggable Databases"
      ]
    },
    {
      "method": "GET",
      "path": "/database/pdbs/{pdb_name}",
      "operationId": "getPDB",
      "summary": "Oracle Database Get a specific pluggable database",
      "tags": [
        "Pluggable Databases"
      ]
    },
    {
      "method": "DELETE",
      "path": "/database/pdbs/{pdb_name}",
      "operationId": "dropPDB",
      "summary": "Oracle Database Drop a pluggable database",
      "tags": [
        "Pluggable Databases"
      ]
    },
    {
      "method": "PATCH",
      "path": "/database/pdbs/{pdb_name}",
      "operationId": "updatePDB",
      "summary": "Oracle Database Update a pluggable database",
      "tags": [
        "Pluggable Databases"
      ]
    },
    {
      "method": "GET",
      "path": "/database/snapshots/",
      "operationId": "getSnapshots",
      "summary": "Oracle Database Get all PDB snapshots",
      "tags": [
        "PDB Snapshots"
      ]
    },
    {
      "method": "POST",
      "path": "/database/snapshots/",
      "operationId": "createSnapshot",
      "summary": "Oracle Database Create a PDB snapshot",
      "tags": [
        "PDB Snapshots"
      ]
    },
    {
      "method": "PUT",
      "path": "/database/snapshots/",
      "operationId": "configureAutoSnapshots",
      "summary": "Oracle Database Configure automatic snapshots",
      "tags": [
        "PDB Snapshots"
      ]
    },
    {
      "method": "GET",
      "path": "/database/snapshots/{snapshot_name}",
      "operationId": "getSnapshot",
      "summary": "Oracle Database Get a specific snapshot",
      "tags": [
        "PDB Snapshots"
      ]
    },
    {
      "method": "POST",
      "path": "/database/snapshots/{snapshot_name}",
      "operationId": "createNamedSnapshot",
      "summary": "Oracle Database Create a named PDB snapshot",
      "tags": [
        "PDB Snapshots"
      ]
    },
    {
      "method": "DELETE",
      "path": "/database/snapshots/{snapshot_name}",
      "operationId": "deleteSnapshot",
      "summary": "Oracle Database Delete a PDB snapshot",
      "tags": [
        "PDB Snapshots"
      ]
    },
    {
      "method": "GET",
      "path": "/database/snapshot_mode",
      "operationId": "getSnapshotMode",
      "summary": "Oracle Database Get snapshot mode",
      "tags": [
        "PDB Snapshots"
      ]
    },
    {
      "method": "GET",
      "path": "/database/dataguard/configuration/",
      "operationId": "getDataGuardConfiguration",
      "summary": "Oracle Database Get Data Guard broker configuration",
      "tags": [
        "Data Guard"
      ]
    },
    {
      "method": "POST",
      "path": "/database/dataguard/configuration/",
      "operationId": "addDataGuardConfiguration",
      "summary": "Oracle Database Add a Data Guard configuration",
      "tags": [
        "Data Guard"
      ]
    },
    {
      "method": "PUT",
      "path": "/database/dataguard/configuration/",
      "operationId": "updateDataGuardConfiguration",
      "summary": "Oracle Database Enable or disable Data Guard configuration",
      "tags": [
        "Data Guard"
      ]
    },
    {
      "method": "DELETE",
      "path": "/database/dataguard/configuration/",
      "operationId": "removeDataGuardConfiguration",
      "summary": "Oracle Database Remove Data Guard configuration",
      "tags": [
        "Data Guard"
      ]
    },
    {
      "method": "GET",
      "path": "/database/dataguard/databases/",
      "operationId": "getDataGuardDatabases",
      "summary": "Oracle Database Get all Data Guard databases",
      "tags": [
        "Data Guard"
      ]
    },
    {
      "method": "POST",
      "path": "/database/dataguard/databases/",
      "operationId": "addDataGuardDatabase",
      "summary": "Oracle Database Add a database to Data Guard",
      "tags": [
        "Data Guard"
      ]
    },
    {
      "method": "PUT",
      "path": "/database/dataguard/databases/{database}",
      "operationId": "updateDataGuardDatabase",
      "summary": "Oracle Database Update Data Guard database role",
      "tags": [
        "Data Guard"
      ]
    },
    {
      "method": "DELETE",
      "path": "/database/dataguard/databases/{database}",
      "operationId": "removeDataGuardDatabase",
      "summary": "Oracle Database Remove database from Data Guard",
      "tags": [
        "Data Guard"
      ]
    },
    {
      "method": "POST",
      "path": "/database/datapump/export",
      "operationId": "createExportJob",
      "summary": "Oracle Database Create a Data Pump export job",
      "tags": [
        "Data Pump"
      ]
    },
    {
      "method": "POST",
      "path": "/database/datapump/import",
      "operationId": "createImportJob",
      "summary": "Oracle Database Create a Data Pump import job",
      "tags": [
        "Data Pump"
      ]
    },
    {
      "method": "GET",
      "path": "/database/datapump/jobs/",
      "operationId": "getDataPumpJobs",
      "summary": "Oracle Database Get all Data Pump jobs",
      "tags": [
        "Data Pump"
      ]
    },
    {
      "method": "GET",
      "path": "/database/datapump/jobs/{owner_name},{job_name}/",
      "operationId": "getDataPumpJob",
      "summary": "Oracle Database Get a specific Data Pump job",
      "tags": [
        "Data Pump"
      ]
    },
    {
      "method": "GET",
      "path": "/database/datapump/jobs/{owner_name},{job_name}/{filename}",
      "operationId": "getDataPumpJobFile",
      "summary": "Oracle Database Get a Data Pump job file",
      "tags": [
        "Data Pump"
      ]
    },
    {
      "method": "GET",
      "path": "/ords/rest/modules/",
      "operationId": "getRESTModules",
      "summary": "Oracle Database Get all REST modules",
      "tags": [
        "REST Services"
      ]
    },
    {
      "method": "POST",
      "path": "/ords/rest/modules/",
      "operationId": "createRESTModule",
      "summary": "Oracle Database Create a REST module",
      "tags": [
        "REST Services"
      ]
    },
    {
      "method": "PUT",
      "path": "/ords/rest/modules/{id}",
      "operationId": "updateRESTModule",
      "summary": "Oracle Database Update a REST module",
      "tags": [
        "REST Services"
      ]
    },
    {
      "method": "GET",
      "path": "/ords/rest/handlers/",
      "operationId": "getRESTHandlers",
      "summary": "Oracle Database Get all REST handlers",
      "tags": [
        "REST Services"
      ]
    },
    {
      "method": "POST",
      "path": "/ords/rest/handlers/",
      "operationId": "createRESTHandler",
      "summary": "Oracle Database Create a REST handler",
      "tags": [
        "REST Services"
      ]
    },
    {
      "method": "DELETE",
      "path": "/ords/rest/handlers/{id}",
      "operationId": "deleteRESTHandler",
      "summary": "Oracle Database Delete a REST handler",
      "tags": [
        "REST Services"
      ]
    },
    {
      "method": "GET",
      "path": "/ords/rest/clients/",
      "operationId": "getOAuthClients",
      "summary": "Oracle Database Get all OAuth clients",
      "tags": [
        "REST Services"
      ]
    },
    {
      "method": "POST",
      "path": "/ords/rest/clients/",
      "operationId": "createOAuthClient",
      "summary": "Oracle Database Create an OAuth client",
      "tags": [
        "REST Services"
      ]
    },
    {
      "method": "PUT",
      "path": "/ords/rest/clients/{id}",
      "operationId": "updateOAuthClient",
      "summary": "Oracle Database Update an OAuth client",
      "tags": [
        "REST Services"
      ]
    },
    {
      "method": "POST",
      "path": "/ords/rest/privileges/",
      "operationId": "createPrivilege",
      "summary": "Oracle Database Create a REST privilege",
      "tags": [
        "REST Services"
      ]
    },
    {
      "method": "POST",
      "path": "/ords/rest/roles/",
      "operationId": "createRole",
      "summary": "Oracle Database Create a REST role",
      "tags": [
        "REST Services"
      ]
    },
    {
      "method": "POST",
      "path": "/ords/rest/autorest/",
      "operationId": "autoRESTEnableObject",
      "summary": "Oracle Database REST enable a database object",
      "tags": [
        "REST Services"
      ]
    },
    {
      "method": "GET",
      "path": "/ords/properties/",
      "operationId": "getORDSProperties",
      "summary": "Oracle Database Get ORDS properties",
      "tags": [
        "REST Services"
      ]
    },
    {
      "method": "PUT",
      "path": "/ords/properties/{key}",
      "operationId": "setORDSProperty",
      "summary": "Oracle Database Set an ORDS property",
      "tags": [
        "REST Services"
      ]
    },
    {
      "method": "DELETE",
      "path": "/ords/properties/{key}",
      "operationId": "unsetORDSProperty",
      "summary": "Oracle Database Unset an ORDS property",
      "tags": [
        "REST Services"
      ]
    },
    {
      "method": "GET",
      "path": "/database/scheduler/jobs/",
      "operationId": "getSchedulerJobs",
      "summary": "Oracle Database Get all scheduler jobs",
      "tags": [
        "Scheduler"
      ]
    },
    {
      "method": "GET",
      "path": "/database/scheduler/jobs/{owner},{job_name}",
      "operationId": "getSchedulerJob",
      "summary": "Oracle Database Get a specific scheduler job",
      "tags": [
        "Scheduler"
      ]
    },
    {
      "method": "GET",
      "path": "/apex/workspaces/",
      "operationId": "getAPEXWorkspaces",
      "summary": "Oracle Database Get all APEX workspaces",
      "tags": [
        "APEX"
      ]
    },
    {
      "method": "GET",
      "path": "/apex/workspaces/{workspace_name}/",
      "operationId": "getAPEXWorkspace",
      "summary": "Oracle Database Get a specific APEX workspace",
      "tags": [
        "APEX"
      ]
    },
    {
      "method": "GET",
      "path": "/apex/workspaces/{workspace_name}/applications/",
      "operationId": "getAPEXApplications",
      "summary": "Oracle Database Get workspace applications",
      "tags": [
        "APEX"
      ]
    },
    {
      "method": "PUT",
      "path": "/apex/workspaces/{workspace_name}/applications/{application_id}",
      "operationId": "createOrUpdateAPEXApplication",
      "summary": "Oracle Database Create or update an APEX application",
      "tags": [
        "APEX"
      ]
    },
    {
      "method": "DELETE",
      "path": "/apex/workspaces/{workspace_name}/applications/{application_id}",
      "operationId": "deleteAPEXApplication",
      "summary": "Oracle Database Delete an APEX application",
      "tags": [
        "APEX"
      ]
    },
    {
      "method": "GET",
      "path": "/apex/statistics/overview",
      "operationId": "getAPEXOverview",
      "summary": "Oracle Database Get APEX instance overview",
      "tags": [
        "APEX"
      ]
    },
    {
      "method": "GET",
      "path": "/database/rdf/networks/",
      "operationId": "getRDFNetworks",
      "summary": "Oracle Database List all RDF networks",
      "tags": [
        "RDF Graph"
      ]
    },
    {
      "method": "GET",
      "path": "/database/rdf/

# --- truncated at 32 KB (34 KB total) ---
# Full source: https://raw.githubusercontent.com/api-evangelist/oracle-database/refs/heads/main/json-structure/oracle-database-structure.json