How to configure Object Storage?

To discuss and share Oracle clouds related topics & features of Software as a Service (SaaS), Platform as a Service (PaaS), Infrastructure as a Service (IaaS). We will try to cover Oracle Autonomous database, EBS, etc.
Post Reply
admin
Posts: 2062
Joined: Fri Mar 31, 2006 12:59 am
Location: Pakistan
Contact:

How to configure Object Storage?

Post 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 10095 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
Post Reply

Who is online

Users browsing this forum: No registered users and 0 guests