Defines the plant schema database information for your Smart P&ID plant structure.
-
This screen is only displayed if the copied plant structure was previously associated with Smart P&ID on the Associate Applications wizard page.
-
An asterisk (*) means a value is required for that box.
Oracle service/alias
Specifies the Oracle Net Service name for the plant database. This value is carried forward from the plant structure definition page and appears only if using Oracle.
Database server
Displays the Node Name of the server on which the SQL Server database resides. This option appears only if using SQL Server.
Database name
Displays the name of the SQL Server database used by the plant to which the application is being associated. This option appears only if using SQL Server.
Oracle tablespace
Select the default tablespace name for your application schema. These tablespaces are defined when the database administrator created the default database instance using Oracle Database Assistant.
Oracle temp tablespace
Select the default temporary tablespace name for your application schema. The temporary tablespace was defined when the database administrator created the temporary database instance using Oracle Database Assistant. If this list is empty, contact your database administrator.
-
We recommend that you do not use SYSTEM for the default tablespace because Oracle uses this tablespace for its own use. This option appears only if using Oracle.
-
If you create new Oracle tablespaces or SQL Server databases after starting this wizard, you must refresh the tablespace list by clicking Back and then clicking Next to return to this page before the new information will display in the appropriate lists.
Database username
Type the user name you want to use for the Smart P&ID schema user. This value, which must be unique in the database, defaults to the plant name that you specified earlier, with the letters "pid" appended.See Understanding Default Database User Names.
Database password
Displays the default database password, as set by your database software. You can change the password for the Smart P&ID database user by typing a new password in the Database password field. We recommend using the default Smart P&ID user name defined above as this password.
Confirm password
Re-type the password.
Smart P&ID reference data path
Taken from the Plant structure path as set previously in the Target Paths screen of the wizard. To select a different path, type the required path or click
the ellipsis button 
to browse to the reference data path for the application options. This field is limited
to 255 characters.
You must specify a reference data path outside the plant structure path to avoid duplicate sets of reference data and longer process times when saving or backing up your plant and also to avoid deleting the reference data if you delete the plant. For example, if the Plant structure path is \\siteserver\sitename\plantname, do not set the Smart P&ID reference data path to \\siteserver\sitename\plantname\refdata.
-
When loading a plant structure, the software checks the reference data folder structure and, if necessary, creates additional folder levels to ensure that all files with the same names are located in unique folder paths.
-
The software sets the related password defaults for the above user name automatically to <default user name> for Oracle and to <default user name> + '1' for SQL Server. In the case of SQL Server running on Windows Server, if you are using SQL Server authentication, you can specify that SQL Server is to use the password validation rules that are used by Windows Server.
-
Database usernames cannot start with a numeric digit and cannot contain any of the following characters: ~ ` ! % ^ & * ( ) - + = { } [ ] \ / ; : ‘ " < > , . ? |
-
Oracle database user names are limited to 30 characters. Because these are derived from plant names that can be up to 64 characters long, the software truncates any excess characters to the maximum allowed in creating the default database user names.
-
Oracle database passwords cannot contain the characters: " ' @. SQL Server database passwords cannot contain the character: '