Allows you to create a replication schema for use when the satellite is working offline. This schema is a replica of the plant schema at the host site. The plant schema is not always replicated, but the plant data dictionary is always replicated.
This page displays only for connected Workshare collaborations.
Oracle alias — Specifies the Oracle net service alias that allows connection to the Oracle database at the satellite site.
Database link — Select the database link that points to your host database server. The drop-down list displays all available database links on your satellite database server. This option displays only for connected different-instance collaborations.
Oracle tablespace — Select the user tablespace of the Oracle database at the satellite location.
Oracle temp tablespace — Select the temporary tablespace of the Oracle database at the satellite location.
Database username — Type the user name you want to use for the replication plant user. This name must be unique in the database. For more information about default database user names, see Understanding Default Database User Names (see ).
Database password — Type the password for the replication database user. This value defaults to the value in the Database username field.
Confirm password — Re-type the password for the replication database user. This value defaults to the value in the Database username field.
-
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 plant names can be up to 64 characters long, the software truncates the characters to the maximum allowed by Oracle in creating the default database user names.
-
Oracle database passwords cannot contain the characters: " ' @
-
SQL Server database passwords cannot contain the character: '