My Oracle Support Banner

Missing Columns When Importing The Data Dictionary For A Schema With Table With Many Columns (Doc ID 2739707.1)

Last updated on JULY 19, 2021

Applies to:

Oracle SQL Developer Data Modeler - Version 20.2 and later
Information in this document applies to any platform.


On : 20.2 version, Logical Models
Product: SQL Developer Data Modeler versions 20.x.

While importing the data dictionary for a schema with table with a large amount of columns, the import log shows all tables successfully imported, however none of the tables in the relational model have the column definitions that exist in the database.  Primary Keys, Foreign Keys and Indexes are successfully imported, but there are no columns. Problem appears to be related to the number of columns in the table.
Expect all column definitions to import regardless of number of columns in the table.

The issue can be reproduced at will with the following steps:

1. As any schema, create 2 table objects:

Table1 has 235 columns
Table2 has 210 columns

2. Follow steps in the following note to import these 2 tables using Oracle Developer Data Modeler 20.3:
   <Note:780369.1> -
How to Connect to an Oracle Database In Order to Import from Data Dictionary?

File-> Import --> Data Dictionary --> Connect to Database --> Select Schema --> Select table object (Table1) --> Finish

3. In looking in Untitled_1--> Relational Models --> Relational_1 --> Tables[1] -->  SCHEMA.TABLE1, it does not show any of the columns being imported. It only shows:

Primary Keys [1]
Unique Constraints
Indexes [1]
Foreign Keys

4. The same steps for SCHEMA.TABLE2 (table with less columns) does show the columns being imported.

Untitled_1--> Relational Models --> Relational_1 --> Tables[1] --> SCHEMA.TABLE2, it shows all the columns being imported

5. Tested setting:
AddVMOption  -Xmx2048M

in C:\datamodeler-\datamodeler\bin\datamodeler.conf

But still cannot see all the columns.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.