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. See Understanding Default Database User Names.
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 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: '