Oracle Database · Schema
Oracle Pluggable Database
Represents an Oracle Pluggable Database (PDB) in a multitenant container database architecture. PDBs are portable, self-contained database containers that share the resources of a container database (CDB).
CloudDatabaseEnterpriseOracleREST APISQL
Properties
| Name | Type | Description |
|---|---|---|
| pdb_name | string | Name of the pluggable database |
| pdb_id | integer | Unique identifier for the PDB within the CDB |
| id | string | The OCID of the pluggable database (OCI managed) |
| containerDatabaseId | string | The OCID of the container database (OCI managed) |
| compartmentId | string | The OCID of the compartment (OCI managed) |
| status | string | Current status of the PDB |
| open_mode | string | Current open mode of the PDB |
| lifecycleState | string | OCI lifecycle state of the PDB |
| total_size | integer | Total size of the PDB in bytes |
| creation_time | string | Timestamp when the PDB was created |
| timeCreated | string | Creation timestamp (OCI format) |
| connectionStrings | object | Connection strings for the PDB |
| freeformTags | object | Free-form tags for resource categorization |
| definedTags | object | Defined tags for resource governance |
JSON Schema
{
"$schema": "https://json-schema.org/draft/2020-12/schema",
"$id": "https://oracle.com/schemas/database/pluggable-database.json",
"title": "Oracle Pluggable Database",
"description": "Represents an Oracle Pluggable Database (PDB) in a multitenant container database architecture. PDBs are portable, self-contained database containers that share the resources of a container database (CDB).",
"type": "object",
"properties": {
"pdb_name": {
"type": "string",
"description": "Name of the pluggable database"
},
"pdb_id": {
"type": "integer",
"description": "Unique identifier for the PDB within the CDB"
},
"id": {
"type": "string",
"description": "The OCID of the pluggable database (OCI managed)"
},
"containerDatabaseId": {
"type": "string",
"description": "The OCID of the container database (OCI managed)"
},
"compartmentId": {
"type": "string",
"description": "The OCID of the compartment (OCI managed)"
},
"status": {
"type": "string",
"description": "Current status of the PDB",
"enum": ["NORMAL", "RESTRICTED", "UNUSABLE", "RECOVERING", "NEW"]
},
"open_mode": {
"type": "string",
"description": "Current open mode of the PDB",
"enum": ["READ_WRITE", "READ_ONLY", "MOUNTED", "MIGRATE"]
},
"lifecycleState": {
"type": "string",
"description": "OCI lifecycle state of the PDB",
"enum": [
"PROVISIONING",
"AVAILABLE",
"TERMINATING",
"TERMINATED",
"UPDATING",
"FAILED"
]
},
"total_size": {
"type": "integer",
"format": "int64",
"description": "Total size of the PDB in bytes"
},
"creation_time": {
"type": "string",
"format": "date-time",
"description": "Timestamp when the PDB was created"
},
"timeCreated": {
"type": "string",
"format": "date-time",
"description": "Creation timestamp (OCI format)"
},
"connectionStrings": {
"type": "object",
"description": "Connection strings for the PDB",
"properties": {
"pdbDefault": {
"type": "string",
"description": "Default connection string for the PDB"
},
"pdbIpDefault": {
"type": "string",
"description": "IP-based default connection string for the PDB"
}
}
},
"freeformTags": {
"type": "object",
"description": "Free-form tags for resource categorization",
"additionalProperties": {
"type": "string"
}
},
"definedTags": {
"type": "object",
"description": "Defined tags for resource governance",
"additionalProperties": {
"type": "object"
}
}
},
"required": ["pdb_name"]
}
Work with this as data
Every JSON Schema 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 schemas
4 MCP tools reach this
find_json_schemasBrowse and filter every JSON Schema in the catalog.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 JSON Schema
curl "https://apis.io/api/v1/json-schemas/oracle-database-pluggable-database"
All schemas
curl "https://apis.io/api/v1/json-schemas?limit=25"
Discovery needs no key. Ratings and market analysis are Pro.
Get an API key
Free tier, no form to fill in. Signing in shares your email address with us — we store it to create your key and to recognise you if you sign in with another provider. See our Privacy Policy and Terms.
A second provider on the same verified email joins the account you already have.