OASyS - Create Smart Grid Tables

This step is required for OASyS and DMS integrations with Responder. If you're implementing both DMS and OASyS, the following configuration needs to be done only ONCE.

This step is performed in your geodatabase.

In this step, you will use an Oracle script provided with the installation to create the necessary Smart Grid tables in your geodatabase. For this step, you may need to have your Database Administrator create a SMARTGRID user that will be the owner of the Smart Grid tables.

Log in to the GIS as the SMARTGRID user. Use applications such as SQL Worksheet or SQL Plus.
Browse to the Oracle script to create the Smart Grid tables. By default, this script is installed here: \Program Files\Miner and Miner\Responder\Developer Resources\Implementation Scripts\Addons. Look for 930_SmartGrid_oracle.sql.
Execute the 930_SmartGrid_oracle.sql script by entering "@" followed by a path to the script (an example follows) and pressing Enter. This script creates the database tables required by to support Responder integration with OASyS and DMS.
```
@ D:\Program Files\Miner and Miner\Responder\Developer Resources\
Implementation Scripts\Addons\930_SmartGrid_oracle.sql
```

The following tables are added to the geodatabase:

SG_RELATIONSHIP

SG_METADATA

SG_TAG_RELATIONSHIP

SG_DYNAMIC_TAG_MAPPER

SG_RTD_MONITOR

SG_DEVICE_SEQ

These tables are not registered with the geodatabase and are not registered as versioned.