(888) 685-3101 ext. 2

Symptom:
Very recently, using SqlDeveloper 4 Data Modeler I tried to pull and import schema object data (i.e tables) to create an Entity Relationship Diagram ERD from an Oracle database.
After carefully going through the required steps, I kicked off the import process. An error popped up immediately on my screen.

The message given:
error:oracle.dbtools.crest.model.design.storeage.Storage.StorageDesign$NullStorageDesign cannot be cast to oracle.dbtools.crest.model.design.storeage.oracle.StorageDesignOracle

SqlDeveloper_data_modeler_import_error_3
Solution:
The fix is to change the settings for system data types directory in Preferences for Data Modeler in SqlDeveloper.
Make it so that the value for this Preferences setting point to the directory or folder containing types.xml and defaultRDBMSSites.xml files. In my case the path value I plugged in is:

C:program filessqldevelopersqldeveloperextensionsoracle.datamodelertypes

Or it could be where ever it is that you placed the Top folder for SqlDeveloper tool on your computer.
–>  sqldevelopersqldeveloperextensionsoracle.datamodelertypes

To make the Preferences Settings changes, Go to SqlDeveloper Menu. Select Tools -> Preferences -> Data Modeler As shown below.

SqlDeveloper_DataModeler_Preferences_Settings

Click OK button to save and exit Preferences Screen.

You are now ready to Import Table objects into SqlDeveloper’s Data Modeler and create your ERD.

Share This