Skip to Main Content

SQL Developer

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!

reverse engineer spatial tables

user6479601Feb 23 2015 — edited Mar 9 2015

HI,

I would like to get in touch with people who are using SDDM for managing the design of their spatial database.

I'm using datamodeler 4.0.3 with Oracle 12c.

I keep running into problems, such as the reverse engineering process that misses the spatial index.

After adding it manually, the DDL preview proposes invalid DDL (the ASC option is not allowed here), with metadata inserted after the DDL for the spatial index :

  CREATE INDEX BGT_ABB_SI ON BGT_ABONNEMENTEN

    (

      POLYGOON ASC

    )

    INDEXTYPE IS MDSYS.SPATIAL_INDEX PARAMETERS ('geodetic=false tablespace=BRAVO ') ;

Furthermore, The sync process keeps looking at the database connect used by the reverse engineerng process, whereas I would like to sync the test database with the (adjusted) model.

Thnaks,

Richard.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 6 2015
Added on Feb 23 2015
3 comments
719 views