Prerequisites

Before you run statements or scripts in the background, complete the following tasks:

• Configure an OCI Object Storage bucket to store execution result files. By default, results are stored in JSON format. You can also choose CSV.

• Ensure the following IAM policies are granted for background executions:

  Allow group <group_name> to read key-family in tenancy
  Allow group <group_name> to read secret-family in tenancy
  Allow group <group_name> to read buckets in tenancy
  Allow group <group_name> to manage objects in tenancy
  Allow group <group_name> to read object-family in tenancy
  Allow group <group_name> to use database-tools-connections in tenancy

• Verify that the Database Tools connection has access to any required OCI Vault secrets.