EXTERNAL TABLE
Offloading Oracle Data to Object Storage and Loading as External Table in an Autonomous Database | Part 3: Oracle OCI Object Storage
Following up the posts here and here, we are explaining today how to make same thing using Oracle OCI Object Storage. The procedure and steps are quite similar so, let’s go and try! Steps Create a bucket Upload file to bucket Create an Auth Token for your user as follows: In a sql editor, execute […]
MoreOffloading Oracle Data to Object Storage and Mounting as External Table in an Autonomous Database | Part Two: AWS S3
Following up the previous post, we are explaining today how to make same thing using Amazon S3. The procedure and steps are quite similar, let’s go and try! Amazon side setup Create a S3 bucket with no public access: Upload datafile: Grab the object URL for later: Create a user in IAM: Grant access to […]
More