Hi Philip ,
i am using DM that is bundled with sql developer ( V 19.2 )
Oracle Db version is 18.104.22.168
Kindly note that view details in popup menu is similar to what you have copied .
DDL preview does not list columns , as copied below, however in DDL preview - in create index statement , column names are seen . Not sure if this is a issue with DM or with operating system
Hi Hariharasudhan ,
can you post here the DDL generated by SQL Developer - select the table in SQL Developer navigator and go to SQL tab.
How do you import that table - standard Data modeler import wizard or using drag&drop from SQL Dev navigator?
Can you check for problems logged in the log file - "View>Data Modeler>External log"?
Probably you have access to dba_users and dba_tables dictionary views but don't have access to other DBA_ prefixed dictionary views. DM uses those 2 views to determines what set of views to use DBA_ or ALL_.
You need to use a user with pure DBA access or pure non DBA access ( or you can revoke select grant for those 2 views for used user )..