span8
span4
span8
span4
In order for the ArcGIS Interoperability extension to successfully display an Oracle Spatial table,the table must have a spatial index.You may need to contact your Oracle database administrator to have the spatial index added.The following example Oracle SQL command will create a spatial index for a table (for the geometry column named 'geom'):
CREATE INDEX my_index ON my_table(geom) INDEXTYPE IS MDSYS.SPATIAL_INDEX;
In order for the ArcGIS Interoperability extension to successfully identify individual features (and show them in a table view),the table must have an integer index.Ensure that the database table has an indexed column with the following properties:
If you already have a column in the table with unique integer values,then you can use the following example Oracle SQL commands to make the column indexed and not null:
ALTER TABLE my_table ADD UNIQUE (my_old_id);ALTER TABLE my_table MODIFY (my_old_id NOT NULL);
If you do not have a unique integer column in the table,then you need to create a new column and set the values with unique integers.The following example Oracle SQL commands will create a new indexed column:
ALTER TABLE my_table ADD my_new_id INTEGER UNIQUE;UPDATE my_table SET my_new_id = ROWNUM;ALTER TABLE my_table MODIFY (my_new_id NOT NULL);
Box.com - 1.Get Content Information for a Folder
Let the Database Do the Work: Reading
Cannot Extend FME Extension for ArcGIS on non-English OS
Performing spatial queries on database tables using the FeatureReader
Oracle Writer - Additional Table Creation Parameters usage
Forcing Upper Case attribute names when writing to Oracle DB
Oracle Workspaces Not Handled by FME 2015
© 2019 亚搏在线Safe Software Inc |Legal