To use SQL Sheet

1. In the Infrastructure Administrator, do one of the following:
   • Click Enterprise and connect to the enterprise industry model . Open a project.
   • Click File and open a project.
2. Click the Industry Model node.
3. Click Industry Model menu > SQL Sheet.
Note: SQL Sheet is installed with Infrastructure Administrator in the <infrastructure_admin>\Bin folder. To start SQL Sheet without using Infrastructure Administrator, create a shortcut of the file <infrastructure_admin>\Bin\SQLSheet.exe. Start SQL Sheet by double-clicking the shortcut.

In SQL Sheet, do any of the following:

To log in - connect

1. Under User, select an Oracle user from the list, and enter the password and the Oracle service name.

   The list is populated when the system user credentials are entered correctly.

2. Optionally, enter the Oracle system user name and password.

   These are required to import or export Oracle (*.dmp) files, or drop users or tables.

3. To connect to another database, click Connect to open the Login dialog box or, in the list of database objects, select Users.

   In the user list, right-click the user and click Connect.

To export an Oracle user to a (*.dmp) file

1. Optionally set export options: Click Tools menu > Options.
2. In the list of database objects, select Users.
3. In the user list, right-click the user, and click Dump Export.

To view the database size

1. From the database objects list, select User Spaces.

   The list displays all database users with their file size.

2. From the database objects list, select Tablespaces.

   The list displays the size of the tablespaces.

3. Expand the node items, and use the context menu to change the size of a tablespace.

To export the current Oracle user to a (*.dmp) file

1. Optionally set export options. Click Tools menu > Options.
2. Click Tools menu > Dump Export.

To create an Oracle user

Note: This is not an enterprise industry model database schema. To create an industry model database schema, use Infrastructure Administrator.
• Click Tools menu > Create User.

To transfer the attribute names to the expression input box

1. From the database objects list, select a database object.
2. Select a table.
3. Select one or more items from the list, right-click and click the appropriate Select option.