I use SQLDM to generate schema DDL for our projects, including APEX-based projects.
For APEX, the generated DDL file is included in the APEX Supporting Objects installation scripts. The idea is that a user can take an APEX application and install it from scratch in their APEX environment.
In APEX, spatial columns and indexes require ‘special’ treatment as the installation occurs through a proxy user - the usual process of inserting a row into user_sdo_geom_metadata is replaced by a call to apex_spatial to do the insert ‘magically’.
Is there an ‘easy/best-practice’ way of generating DDL from SQLDM to support both the ‘normal’ and the APEX ‘way’ of doing this? Should I just manually create ‘After Create’ scripts to call the apex_spatial/create the index and then remember to switch off ‘Register Spatial Table’ or ‘After Create Include in DDL’ depending on where the script will be used?