Managing External Database Handles

This topic provides information on managing Oracle Cloud Infrastructure (OCI) external database handles using the OCI Console and API. See External Database Service for an overview of the External Database service.

Note

See the Database Management documentation for instructions on enabling Database Management for an external database handle in the OCI Console.

Required IAM Policy

To use Oracle Cloud Infrastructure, you must be granted security access in a policy  by an administrator. This access is required whether you're using the Console or the REST API with an SDK, CLI, or other tool. If you get a message that you don’t have permission or are unauthorized, verify with your administrator what type of access you have and which compartment  to work in.

For administrators: The policy in Let database admins manage Oracle Cloud external database resources lets the specified group do everything with databases and related Database resources.

If you're new to policies, see Getting Started with Policies and Common Policies. For more information about writing policies for databases, see Details for the Database Service.

Using the Console

To move an OCI external database handle to another compartment
Note

For information on using compartments, see Understanding Compartments.
  1. Open the navigation menu. Click Oracle Database, then click External Database.
  2. Choose your Compartment.
  3. Under External Databases, click either Pluggable Database, Container Databases, or Non-Container Databases, depending on the type of external database handle you are managing.
  4. In the list of external database handles, click on the name of the handle you want to move.
  5. On the external database details page, click the Move Resource button.
  6. In the Move Resource to a Different Compartment dialog, choose a new compartment using the drop-down selector.
  7. Click Move Resource.
To delete an OCI external database handle

This topic describes how to delete the following OCI resources:

  • External pluggable database handle
  • External container database handle
  • External non-container database handle
Note

  • If your external database handle has an associated database connection resources, you must first delete the connections before you can delete the external database handle.
  • For external container databases, you cannot delete the OCI handle until all of the external pluggable database handles in the container database handle have first been deleted.
  1. Open the navigation menu. Click Oracle Database, then click External Database.
  2. Choose your Compartment.
  3. Under External Databases, click either Pluggable Database, Container Databases, or Non-Container Databases, depending on the type of external database handle you are deleting.
  4. In the list of external database handles, click on the name of the handle you want to delete.
  5. On the external database details page, click the Delete button.
To scan an external container database for pluggable databases
  1. Open the navigation menu. Click Oracle Database, then click External Database.
  2. Choose your Compartment.
  3. Under External Databases, click Container Databases.
  4. In the list of external container database handles, click on the name of the handle that is connected to the container database you want to scan.
  5. On the external container database details page, click Scan for Pluggable Databases.

    If any pluggable databases are discovered that are not connected to Oracle Cloud Infrastructure, the connection details for these databases are listed in the work request generated by the scan operation.

Using the API

For information about using the API and signing requests, see REST APIs and Security Credentials. For information about SDKs, see Software Development Kits and Command Line Interface.

Note

For links to APIs for enabling or disabling associated services including Database Management and Operations Insights, see Using the API in the Managing Associated Services for External Databases topic.

Use these API operations to manage external container database resources:

Use these API operations to manage external pluggable database resources:

Use these API operations to manage external non-container database resources: