Importing Data using Oracle Data Pump
You can import data from Data Pump files into your on-premises or cloud database.
For more information about Data Pump import, see Data Pump Import in Oracle Database Utilities.
Topics:
Requirements
-
Log in as the ADMIN user in Database Actions and enable resource principal for the Autonomous Database:
In the SQL worksheet page, enter:
EXEC DBMS_CLOUD_ADMIN.ENABLE_RESOURCE_PRINCIPAL();
-
Obtain the resource.id.
In the Oracle Cloud Infrastructure console, select Oracle Database and then select Autonomous Databases. In the Database tab, click the Actions icon (three dots) and select Copy OCID. This is applicable for all database instances in all the compartments.
-
Create a dynamic group.
-
In the Oracle Cloud Infrastructure console, click Identity and Security and click Dynamic Groups.
-
Click Create Dynamic Group and enter all the required fields. Create matching rules using the following format for all your databases:
any { resource.id = ' here goes the OCID of your database 1', resource.id =' here goes the OCID of your database 2' }
Note:
For managing dynamic groups, you must have one of the following privileges:- You are a member of the Administrators group.
- You are granted the Identity Domain Administrator role or the Security Administrator role.
- You are a member of a group that is granted manage identity-domains or manage dynamic-groups.
-
-
Create a new policy.
-
In the Oracle Cloud Infrastructure console, click Identity and Security and click Policies.
-
Click Create Policy and enter the required fields. In the Compartment field, it is recommended to enter root . If the policy is configured at a lower-level compartment, the dynamic group will not apply for future compartments at levels above that one.
-