Database DataWarehousing (MOSC)

MOSC Banner

Getting authorization error message when loading into ADW from Oracle Object Storage

edited Jun 13, 2019 4:37PM in Database DataWarehousing (MOSC) 10 commentsAnswered ✓

Hello,

I am working through the tutorial for loading data into ADW from Oracle Object Storage (here is the URL for the tutorial: https://www.oracle.com/webfolder/technetwork/tutorials/obe/cloud/adwc/OBE_Loading%20Your%20Data/loading_your_data.html ).  I did all of the steps in the tutorial including generating a token for the Object Store and then establishing the object store credentials in the ADW for the user/schema where the target tables are present (ie adwc_user).

In the tutorial it says that it is necessary to give privileges for loading data to the user that was used in the tutorial (ie adwc_user).  I gave the adwc_user data loading privileges as suggested in the tutorial using the following command: GRANT UNLIMITED TABLESPACE TO adwc_user; (I did this when I was connected as ADW Admin).

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