Industry Model Context Menu

The following commands on the industry model root node context menu affect the whole industry model. Some of the commands can also be started from the topic or feature class level.

Some of the commands can also be started as a batch.

To display the context menu, right-click the industry model node item in the data model explorer and click a command, as shown in the following table:

Industry Model Node	Description
Empty	Empties the tables (TRUNCATE) of feature data, but retains the tables and schema.
Create Grants	Creates the required grants for the current enterprise industry model (Oracle commands) for troubleshooting.
Set Environment Variables	Reads some settings from TB_INFO and saves them for the session: - Index table space (TB_TMP_MGMT) - name of TBSYS. Creates all user synonyms on MAPSYS; sets all required settings for a job package and recreates the package; creates a context that corresponds to user names; and re-creates ON_LOGON trigger.
Compound	Uses sub-commands to process compounds. See also Data Model: Compounds.
UFID	Uses the following sub-commands to process indices: UFID (unique feature ID) and FID (feature ID)
Reset FID Sequence	Resets the FID sequence to start from the beginning. This is necessary, when an industry model has been emptied. You can also reset the FID sequence if the sequence does not match the maximum FID value from the TB_UFID table.
Cleanup UFID Table	Deletes all FIDs from TB_UFID that have no corresponding feature. If there are many unnecessary entries this may improve performance. 1-Click-Maintenance: TB_UFID.
Restore UFID Table	Restores missing entries in TB_UFID, for example, if values have been deleted manually. 1-Click-Maintenance: TB_UFID.
Spatial >	Uses sub-commands to process spatial indices.
Insert Or Update Spatial Metadata	Inserts or updates spatial metadata (minimum and maximum of X and Y, the SRID, spatial Tolerance and dimension); Stored in TB_DICTIONARY. 1-Click-Maintenance: Spatial Configuration.
Create Or Replace All Spatial Indices	Creates or replaces spatial indices. 1-Click-Maintenance: Spatial Configuration.
Drop All Spatial Indices	Deletes spatial indices.
Check Spatial Config. For System Tables	Writes spatial metadata and spatial indices for TB_PERIMETER and TB_JOB_PERIMETER. Stored in TB_INFO.
Update Coordinate System	Updates the coordinate system. See also About Coordinate Systems.
Round Geometry On All Feature Classes	Rounds the geometry, for example, if you have the Round Geometry feature rule enabled, and want to adjust imported data.
Triggers >	Uses sub-commands to process triggers.
All Triggers	Creates or replaces, enables or disables all triggers.
Compound Triggers	See Data Model: Compounds.
Optimization	Uses sub-commands for database optimization (DBMS_STATS*). These are important for the Oracle optimizer to generate optimal execution plans. For more information refer to Oracle Spatial Users Guide and Reference.
Optimize Schema	Runs the DBMS_STATS.GATHER_SCHEMA_STATS(USER,cacade=>true) command. This procedure gathers (not estimates) statistics for all objects in a schema and on the indexes. Optimize the schema after you import a industry model from a dump file, and run the Optimize command whenever you have extensive changes to the data, such as imports or major updates.
Optimize Feature Classes	Runs the DBMS_STATS.GATHER_TABLE_STATS([USER], [Table], cascade=>true) command for the feature class tables. This procedure gathers table, column, and index statistics. 1-Click-Maintenance: Gather Statistics.
Optimize System Tables	Runs the DBMS_STATS.GATHER_TABLE_STATS([USER], [Table], cascade=>true) command for the following tables: TB_UFID and TB_JOB_VERSION. This procedure gathers table, column, and index statistics.
Update Label Texts	Updates all label texts of all label feature classes. See also Label Commands.
Jobs >	Uses a sub-command to process jobs.
Choose Job	Selects a job for job-enabled industry models. For commands that process feature classes, you must select a job, for example, for Update Area Attribute, or Update Label Texts.
Erase Job History For Live Features	For live jobs, removes all historical elements that are stored in the feature class and the TB_JOB_VERSION table. See also System Tables TB_JOB_* Before removing historical elements, the data in TB_JOB_VERSION is validated against some internal criteria. When the validation process finds invalid data, an error message informs the user and the process stops. The user can execute 1-Click Maintenance to find more details.
Convert Tables To Feature Classes	Converts Oracle tables to enterprise industry model feature classes. Analyzes the industry model schema, and opens the Convert To Schema dialog box. Data Model: Oracle Schema Converter.
SQL Protocol	Opens the SQL Protocol window, where you can create a log file of SQL statements that the data model administrator executes during your work. You can control which type of statements to log. You can copy or save the statements for future use. Once you close the SQL Protocol window the logged statements are removed.
Refresh	Reloads the data structure tree from the tables, displaying any changes you made. Use this command or press F5.