In this post I will share how we can use Portworx CloudSnap to backup a Kubernetes Portworx volume to an Oracle Cloud Infrastructure (OCI) Object Storage S3 Bucket. OCI Object Storage Let's start by logging into an Oracle Cloud Infrastructure (OCI) account, and from the Dashboard selecting Object Storage or via the hamburger menu navigate to Storage -> Object Storage -> Buckets.... Continue Reading →
Accessing on-premises S3 Object Storage from Oracle 19c or 21c databases with DBMS_CLOUD
In this post I will share to how to create an external table using the DBMS_CLOUD package and then run a query against a csv file uploaded into a Pure Storage FlashBlade S3 Object Storage bucket. I have previously shared how to install and configure the Oracle DBMS_CLOUD package, if you want to follow this... Continue Reading →
Working with Oracle 19c database and on-premises S3 Object Storage with DBMS_CLOUD
The DBMS_CLOUD package has been available for on-premises 19c database for over a year now, and since the initial 19.9 release several fixes have been shipped, so I suggest you consider using the latest patch if possible, to avoid any known issues. I have previously shared how to configure an Oracle 19c database to use DBMS_CLOUD... Continue Reading →
How to access a FlashBlade Object Store from within your Oracle 19c database
Introduction Last year I wrote a number of posts on Big Data and shared how we can access CSV, Parquet and Avro file formats directly from an on-premises Oracle 19c database using Oracle external files on a local file system or and NFS share from an NFS server e.g. FlashBlade Unfortunately, at that time I... Continue Reading →
Getting started with Oracle Cloud Infrastructure (OCI) Object Storage
Introduction In my post How to access Object Storage from your on-premises database I showed how we configure an Oracle 19c (19.9+) database to use the DBMS_CLOUD package to access objects stored within Object Stores. In this post I will share how I created the Oracle Cloud Infrastructure (OCI) Object Store bucket and objects I... Continue Reading →
How to access Object Storage from your on-premises Oracle 19c Database
Introduction Last year I wrote a number of posts on Big Data and shared how we can access CSV, Parquet and Avro file formats directly from an on-premises Oracle 19c database. In these posts I demonstrated how we can access different file types using SQL external tables on a file system, unfortunately I quickly run... Continue Reading →