SQL Developer Data Modeler

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!

Oracle SQL Developer Data Modeler Reverse Engineering for AWS RDS Oracle

User_7RC08Nov 9 2022

Hi team
I would like to use Oracle SQL Developer Data Modeler Reverse Engineering to generate a Data Modelling from a RDS Oracle instance. I can connect it successfully, but not list any schema in 'select schema page' using Wizard. I find below error message in the log file as below. How to fix it? Thank
Caused by: Error : 942, Position : 40, Sql = SELECT NAME,OWNER,IRID,DESCRIPTION FROM i$sdd_workareas, OriginalSql = SELECT NAME,OWNER,IRID,DESCRIPTION FROM i$sdd_workareas, Error Msg = ORA-00942: table or view does not exist
Regards,
NP

Added on Nov 9 2022

0 comments

310 views