Creating Pluggable Databases via ORDS REST APIs: Asynchronous Workflow with DBMS_SCHEDULER Jobs
By
thatjeffsmith
A respectable bake. You'd come back tomorrow for another.
Summary
This article demonstrates how to create or clone Pluggable Databases (PDBs) using ORDS (Oracle REST Data Services) Database REST APIs. It highlights that as of ORDS version 24.1, this operation has been improved to work asynchronously via DBMS_SCHEDULER jobs. The author provides an example of setting up a Container (CDB) install of ORDS, making PDBs addressable, and creating an ORDS ADMIN database user. The example shows a request that creates a task and returns a link to follow for status updates, though the specific example given is noted as one that will fail but still illustrates the workflow.
Key quotes
· 3 pulledThis is literally a bad example. It will FAIL fast, but it still shows the workflow.
Our request succeeded, in that the task created, and we were given a link to follow.
I've done a Container (CDB) install of ORDS, and made my PDBs addressable, and have created an ORDS ADMIN database user in the CDB to make this possible.
You might also wanna read
PostgreSQL 18 Enables Instant Database Cloning with Reflinks
The article explains how PostgreSQL 18 introduces new file copy options that enable instant database cloning using reflinks, solving the pro
boringsql.com·5mo ago
Designing Database Management Systems for Telecommunications Requirements
The article discusses the design considerations for a Telco Database Management System (DBMS) that must handle critical telecommunications o
mikaelronstrom.blogspot.com·9mo ago
Conceptual Analysis: Using SQLite as Storage Engine for OpenDocument Presentation Format
This article presents a thought experiment exploring how the OpenDocument Presentation (ODP) format could benefit from using SQLite as its u
PlanetScale Launches General Availability of Postgres Database Service
PlanetScale has announced that its Postgres database service is now generally available after being in private preview. The article provides
planetscale.com·8mo ago
Mergeable Containers: Solving Concurrent Child Creation Conflicts in CRDTs
This article discusses a fundamental problem in JSON-like CRDTs (Conflict-free Replicated Data Types) where concurrent creation of child con
DuckDB v1.4 Database Encryption: Implementation, Usage, and Performance Analysis
DuckDB v1.4 introduces database encryption capabilities for data-at-rest protection. The article explains the implementation details of the
duckdb.org·6mo ago