Page 1 of 1

How to configure Object Storage?

Posted: Sun Sep 15, 2019 6:41 am
by admin
While using autonomous you will need a process to upload as in this you don't have access to OS so you can use directly copy to the server. Oracle provided Object Storage inside your cloud which you can create very easily and use. You can do this in 3 steps,
object_storage1.jpg
object_storage1.jpg (91.37 KiB) Viewed 11038 times
1- Create a bucket inside Object Storage.
2- Upload files in this bucket.
3- Create an Object Store Auth Token and copy data from storage to your database (transaction or warehouse).


-- Drop if already created credentials.

BEGIN
DBMS_CLOUD.DROP_CREDENTIAL(credential_name => 'OBJ_STORE_CRED' );
END;

-- Follow the link provided at the end of this post and follow step 2. Create an Object Store Auth Token

BEGIN
DBMS_CLOUD.CREATE_CREDENTIAL(credential_name => 'OBJ_STORE_CRED',
username => 'admin@erpstuff.com',
password => '*************');
END;

-- Following steps will copy file from object storage to DATA_PUMP_DIR which you can now use in your database.

BEGIN
DBMS_CLOUD.GET_OBJECT(
credential_name => 'OBJ_STORE_CRED',
object_uri => 'https://objectstorage.us-ashburn-1.orac ... wallet.sso',
directory_name => 'DATA_PUMP_DIR');
END;

https://www.oracle.com/webfolder/techne ... _data.html