PL/SQL (MOSC)

MOSC Banner

Error trying to load an object from object storage into the database

edited Sep 14, 2020 11:23PM in PL/SQL (MOSC) 1 commentAnswered

Tried to create a DBLink between two autonomous shared databases using Document 2592265.1.

The following steps were followed

1. Create a new user (Identity -> Users)     Associated the user under the group "Administrators"     Created a Auth Token

2. Uploaded the Wallet file of the Target database "Cwallet.sso" obtained from ATP -> DB Connection ->  Download Credentials, in to the object storage

3. Created a DB Credential using, The newly created username, The Auth Token and a custom credential name

4.  Tried to upload the Wallet file from Object storage in to the database BEGIN   DBMS_CLOUD.GET_OBJECT   (     credential_name => ,     object_uri      => ,     directory_name  => 'DATA_PUMP_DIR'   ); END; /

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center