Skip to Main Content
Set up live data sharing between Oracle Databases using Cloud Links and PL/SQL APIs

About This Workshop

Youtube Video

About This Workshop
Learn how to share live data with Cloud Links using PL/SQL in Autonomous Database. The benefits are:
- Data is securely shared
- Data is not replicated as it's managed in a single place
- Easily manage data access privileges
- Easy to find data you're interested in
- Consumers don't need to understand the details - they simply access the data using the cloud link and start using it

Workshop Info

1 hour
  • Introduction
  • Set up the Workshop Environment
  • Create a Share Provider User, an Object Storage Bucket, and an OCI Credential
  • Grant the Required Privileges to the Share Provider User
  • Obtain Consumer Share ID
  • Identify the Share Provider
  • Verify Identity Credentials
  • Create, Populate, and Publish a Data Share
  • Create and Authorize the Data Share Recipient
  • Consume Data Share using a Cloud Link
  • Provision and use an ADB instance
  • Create and manage Oracle Object Storage buckets
  • Familiarity with Oracle Database and SQL and PL/SQL is desirable, but not required
  • Some understanding of cloud and database terms is helpful
  • Familiarity with Oracle Cloud Infrastructure (OCI) is helpful

Other Workshops you might like