Skip to Main Content

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!

Cannot import data dictionary in Data Modeler

mbarisonDec 7 2021

Hi, I am using Oracle SQL Developer Version 4.2.0.17.089, connecting to a Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 database.
I am trying to import tables into Data Modeler, but it doesn't work. I can connect to the database and select a schema, but then the schema appears empty, with no tables nor views. I have tried several schemas, with the same result.
I have read in other bug reports that you need access to the ALL_ views, and I checked that I have access to ALL_TABLES, ALL_VIEWS, ALL_USERS, ALL_SOURCE
This is the only DB where importing data dictionaries doesn't work, other instances work fine, so it seems like it's just a matter of user rights, but I would like to understand which ones exactly.
Thanks!

Comments
Post Details
Added on Dec 7 2021
3 comments
613 views