Skip to Main Content

SQL Developer for VS Code

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

can't generate table DDL in VS Code

user2834461Feb 26 2025

Can't read Table ddl in VS Code. All other menu part are Ok. Got "An error occurred while generating DDL for "C##UAM"."REORG_CMD". The resource does not exist in this environment or the user making this request is not authorized to access the resource. Check the spelling of the resource. Check the user has authorization to access this resource"

But SELECT DBMS_METADATA.GET_DDL('TABLE', 'REORG_CMD', 'C##UAM') FROM DUAL;

In sql editor works fine
I don't see thsi problem as SYS user.

Comments

Post Details

Added on Feb 26 2025
4 comments
103 views