Categories
- All Categories
- Oracle Analytics Learning Hub
- 33 Oracle Analytics Sharing Center
- 22 Oracle Analytics Lounge
- 256 Oracle Analytics News
- 45 Oracle Analytics Videos
- 16.1K Oracle Analytics Forums
- 6.3K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 97 Oracle Analytics Trainings
- 16 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
FAW - BI- Invalid credential name
Hi All,
We are trying to run the below sql query in OAC BI Publisher using OAX_USER (data Source) getting 'Invalid credential name'. Please share your input if you have faced similer issue,
SQL Query
===============================================
select * from dbms_cloud.list_objects(
'TEMP_DATA_STORE.DATA_STORAGE_CREDENTIALS',
'https://objectstorage.uk-london-1.oraclecloud.com/n/{my-namespace}/b/ob-bucket/o/')
Error Message
===================================================
Invalid credential name - TEMP_DATA_STORE.DATA_STORAGE_CREDENTIALS ORA-06512: at "C##CLOUD$SERVICE.DBMS_CLOUD$PDBCS_240425_1", line 2060 ORA-06512: at "C##CLOUD$SERVICE.DBMS_CLOUD$PDBCS_240425_1", line 12567 ORA-06512: at line 1
Regards,
Best Answer
-
This is an Expected behavior you can't able to run the select command on dbms_cloud.
ORA-20004: Credential "OAX_USER"."OBJ_STORE_CRED" does not exist
DBMS_CLOUD is owned by a separate C##CLOUD$SERVICE schema.
Refer - How To Setup And Use DBMS_CLOUD Package (Doc ID 2748362.1)
Regards,
Arjun
1
Answers
-
I hope we have answered your question, Can you accept the same and close the thread.
Regards,
Arjun
0 -
Any update on your thread? Can we conclude the same, if you are fine with responses.
Regards,
Arjun
0 -
@Vasanthakumar Ravi Could you please mark the appropriate answer as "accepted" in this thread?
This will allow other forum users to benefit from this thread as it will showcase and highlight the pertinent and valid answers, thereby allowing for a faster problem solution for other users experiencing the same issues as yourself.
Thank you,
Namrata
0
