Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 44 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 278 Oracle Analytics and AI News
- 56 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 103 Oracle Analytics and AI Trainings
- 20 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
